Friday, February 24, 2012

handling double quotes

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