jerry-621596 (1/9/2013)
Which transformation and destination components are you using?
In my data flow, I have a Flat File Source which connect to a
OLE DB Destination
anthony.green (1/10/2013)
You will need to set a text qualifier on the source csv file connection manager.... I bet if you open the file in notepad they will show.
Yes, you are right, I can now see the quotes in notepad.
As for the Text Qualifier... In the Multiple Flat Files Connection Manager Editor, under the General tab, the Text qualifier box was set to <none> I have tried putting in a quotes " and double quotes "" to no avail - the import job fails (if thats what you mean?).
And inserting quotes in the text qualifier also warns me that 'the flat file parser does not support embedding text qualifiers in data...'