June 28, 2011 at 7:45 am
I have a flat file output with several string datatype columns in it .
I want the string datatype columns in the csv file in the inverted commas and other as the same.
For eg i have two columns id int,
name Varchar(10)
then my flatfile output should be like 1,"sql"
2,"sever"
I am unable to figure it out...
June 28, 2011 at 1:40 pm
In the flat file connection manager, type " in the text qualifier text box. (in the general pane at the format section)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 28, 2011 at 1:42 pm
To clarify are you saying you have two rows in your data flow with an int and a string and you want to export them to a csv? That should be pretty straight forward, just define the flat file destination with an int and a string column and map the columns appropriately.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply