CODEWITHSUNDEEP
ssis
P. MAJ
P. MAJ

Reputation: 159

SSIS - How to insert all values inside ""

there is a requirement for all the values integrating from SQL Server into a flat file (.csv) being inserted between a double quotation mark, such as 123 to be inserted as "123". I am having such difficulty with this, i tried the derived columns with the script "\"\"" + [columnName] + "\"\"" but does not work at all. Please be advised i need the column headers to have the same "" as well.

Many thanks!

Upvotes: 0

Views: 88

Answers (1)

iamdave
iamdave

Reputation: 12243

If you mean you want to export data from SQL Server into a csv file using SSIS, and that you want the values to be double quoted, you just need to set the Text Qualifier property of your Destination connection to a double quote " character.

Upvotes: 1

Related Questions