Hi
i am importing data from table to flat file(csv). i have two problems
1. if a column has commas(,) it should not create a new column i.e the column in csv file can have commas
2.if a column has double quotes then csv file column should have double quotes. please help me.I am using derived column I dont know how to search double quotes in string.
if my table has 2 columns
col1 col2
a abc,"scfddf"ghisk
b bc,de
c de
my csv file should look like this
a abc,"scfddf" ghisk
b bc,de
c de
thanks
I don't understand... You define two columns in the file connection manager and just hook up the data flow columns to it.In the examples you've given above, I don't see a need for the derived column transformation.
What are you seeing in your results?|||I agree, if you hook up an OLEDB Source to Flat file in your data flow task, this should already get handled automatically.
No comments:
Post a Comment