March 23, 2011 at 2:31 am
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.
Please share your thoughts regarding this.
With Regards
Navaneeth.S
March 23, 2011 at 4:21 am
Please don't crosspost. It shatters replies around the site and it wastes peoples time.
Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1082508-391-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 11, 2011 at 2:41 pm
Yes you can. In your Data Flow design, double click on your Flat file destination. Put col1, col2, col3 without double quote in the Header text box.
In your Flat file connection, make sure you uncheck the check box for Column names in the first data row.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply