This SSIS article shows how to export SQL Server table records or data to a flat file with text qualifier (double quotes) as an example.
The below screenshot shows the records in the Employee table.
SSIS Export SQL Data to Flat File with Text Qualifier
Drag and drop the Data Flow Task into the control flow region.
Double-click to open the SSIS Data Flow Region. Then, drag the OLE DB Source and double-click on it to open the Editor. Next, click the New button to configure the OLE DB Connection Manager. Here, we have chosen the existing one, but you can create a new one by clicking the New button.
We will choose the existing employee table from the list in this example. Next, go to the columns tab to check the columns and click the Ok button. For more Data Loading options >> Click Here.
Drag the flat file destination and connect the OLE DB source to it. Next, Double-click on the flat file destination to open the Editor, and click on the new button to choose the flat file format. Here, we have chosen the Delimited as the format option.
Click the Browse button to create a new Employee with Double Quotes file to store the records.
Next, specify the TextQualifier and checkmark the Column Names in the first data row option to copy the headers.
Use the advanced tab to change the Data type or column names. After you finish, click OK to close the window.
Within the Flat File Destination Editor, go to the Mappings tab to check the input and available destination column mapping.
Run the SSIS Export SQL Server Table Data to Flat File with Text Qualifier package.
As you can see, all the records in the flat file have double quotes as the text qualifier.
Let me change the Text qualifier to ** and run the package.
See the result.