SSIS execution log show errors at different row

Question

I have a job that import from a csv file to SQl server table.
It failed today with error, the log shows it failed at row 5033 for columnX, conversion error.
But if I go to the row, I don't see there is anything wrong with it. the columnX is OK regarding type and length.

I ran it again, same source file, this time it shows error at a different row 2035
I found this is because the column is maxed out the data type length in the table.

My question is why it shows different rows each time even it is the same file.
I wonder each time when SSIS do import from csv file, do they process in the order of the row orders in the csv file?

Thanks,

Answer 1

Hi @Anne ,

Please configure error output of the source to get error data in ssis data flow task.

Hope the following links and pictures:

1. Lesson 4-3: Add error flow redirection
2. An overview of Error Handling in SSIS packages

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?

Answer 2

Thank you, Yes I did use the way for redirect errors and found the problem.
But my question is still now answered, I am wondering why same file, same process, I run twice but the execution log gives error on different row.
When the ssis import from csv file, does it process each time the order of the rows in csv file, or different?

Thanks