Friday, March 9, 2012

error 0xc0202055...while import data from csv file

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