I receiveed the error:
Error 0xc0202055: Data Flow Task: The column delimiter for column "Column x" was not found.
I would like to have the import continue., even the error occur. I have the error output to ignore, but doesn't seem to be working. Any suggestion on what to do next, or how to skip the row that create the problem.
thanks
We'll need a little more information - is the .csv file in a valid format? Does it have an inconsistent number of columns? If so, you should check out these posts - one for a workaround, the other for another workaround and some background info.
http://agilebi.com/cs/blogs/jwelch/archive/2007/05/07/handling-flat-files-with-varying-numbers-of-columns.aspx
http://blogs.conchango.com/jamiethomson/archive/2007/05/15/SSIS_3A00_--Flat-File-Connection-Manager-issues.aspx
No comments:
Post a Comment