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

Error 0xC0047012 trying to import flat file in SSIS

I'm trying to do a simple flat file import of a .csv file. The task keeps failing on me and I get the following error

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039

I looked up the error codes and the only information I can find is that a thread is failing. What would cause this and how can I fix it? I can open the same file in Excel without any problems. I'd really appreciate any insight that anyone has to offer.

Does your package do anything else than importing the flat file?

Could you try nail down a piece of data in your file that is causing this? You can do it by splitting the file in two and keeping the failing part until you get the minimal amount of data causing this failure.

If your data is not sensitive I would like to do some testing with your file as well.

Thanks.

|||

Bob,

Thank you for the tip. I've been working on it all day and finally started coming to the same place you mentioned. I was finally able to get rid of the error by modifying the column data types in the Flat File connection.