Phil Parkin (3/9/2011)
Koen Verbeeck (3/9/2011)
natarshia.peck (3/8/2011)
Helloi am running into a similar problem with the embedded double quotes.
I tried using the redirect row on error to just skip those rows with the double quotes.
I have not gotten it to work. Does anyone know of a way to just skip over that row and keep processing?
How exactly is this causing troubles?
For testing purposes, I loaded a flat file with embedded double quotes into SSIS 2008 and it imports just fine.
Really - even though you specified " as the text-field delimiter?
Yes. But then I did some more testing, and it starts to screw up when there are double quotes AND commas in one string.
Conclusion: use another delimiter for god's sake. The comma is one of the most used punctuation marks in strings. Use a pipe | as a delimiter, because who uses that symbol in a normal sentence? 99% of your problems will go away.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP