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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics