put flat file data in double quotes except column names in ssis
Hi,
I'm trying to export data from SQL Server tables to a text file (with comma as delimiter) with text qualifier. My output looks like:
"Col1","Col2","Col3"
"1","New York","USA"
"2","London","England"
"3","Chicago","USA"
"4","Paris","France"
Here the first row is the column header and remaining are the output of a query. I use " as the text qualifier because Col2 and Col3 may
contain comma. I can't change the delimiter as the downstream system expects "," separated values.
Is there any way where I can get my output as given below:
Col1,Col2,Col3
"1","New York","USA"
"2","London","England"
"3","Chicago","USA"
"4","Paris","France"
There should not be text qualifiers for header rows.Naresh
September 28th, 2012 5:43am