March 18, 2014 at 1:50 pm
I created SSIS package with simple data flow: Source -> Data Conversion -> Destination tasks.
It pours data from one table to another within the same database.
After running for 3+ hours, it crashed. If I check tab Exceution results, at the end I only see 2 records with their icons marked as red:
Task Data Flow Task 1 failed.
Finished, 3:26:33 pm, Elapsed time: 03:31:36.551
How to find the error record with the reason why it failed?
Thanks
March 18, 2014 at 3:07 pm
Create a table that has the same column definitions as your source and add 2 additional columns (ErrorCode int, ErrorColumn int). Add a destination connection in your package. grab the red arrow from your source and drag it to the destination object and do your mappings. This will output the bad rows to the new table you created and give you an error code and what column number caused the error.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply