CODEWITHSUNDEEP
ssisdatasource
ob213
ob213

Reputation: 492

Ignore errors on Data Source in SSIS

I have 3 million rows customers.csv file. When I import it in SQL 2008, I am getting a data source step in a data flow. "[Source - Customers_csv [1]] Error: The column delimiter for column "CCode" was not found." CCode is the last column in the file.

The error is on data row 82824. I can't open this 2GB file to look what is going on.

How could I just ignore this error?

ob

Upvotes: 0

Views: 2614

Answers (2)

ob213
ob213

Reputation: 492

I set redirect to error output, added the data viewer to it and was able to look at the erroneous row. The row had text qualifiers and column delimiters messed up.

Upvotes: 0

Shiraz Bhaiji
Shiraz Bhaiji

Reputation: 65381

Try setting "Ignore failure" on both errors and truncation. See:

http://www.safnet.com/writing/tech/archives/2007/08/ignoring_ssis_d.html

Upvotes: 1

Related Questions