Jan 15, 2010 at 8:11 PM
Edited Jan 15, 2010 at 11:44 PM
I have rows in a CSV that have a " (double quote) text qualifier,
\" (backslash + doublequote) escape char and CR+LF row delimiter.
I am reasonably new to SSIS and have been struggling with this file for a couple of days. I moved to the DFS 2008 source in hopes that it would fix all my issues with this.
It has helped enourmously! As I am now able to import data without failure.
However, the data I am getting is still incorrect.
I set the following:
text qualifier = "
escape char = \"
The escape char doesn't seem to keep. It just reverts to \
I have written a C# script to remove the \", but by the time it gets to the script it is just a \ (no quote), because I set the text qualifier to quote.It seems to remove them both... ??? I can't exactly remove a backslash at that time
because it might be a part of the actual string.
Here is an example row
140,2001543686,"\"Vintage YADA YADA YADA - blah blah blah blah - yada yada, 1234567 \" http://bit.ly/7aHhw","2009-06-02 08:14:06","GreenSpotting","2009-11-17 17:16:55"
I considered running a C# script on the CSV before it even gets to the data flow. This seems like my only option right now, but I prefer not to do double the work, if I am already reading this thing in row by row.
Any help would be greatly appreciated.