Here is a very cryptic error message which managed to puzzle me a bit: "The…
In SQL Server Integration Services (SSIS), you have to option to Redirect records that can’t be inserted or updated in a dataflow task to the ”Error Output”. This is very useful as you can investigate and handle those records separately without failing the whole package, and when you use the ”Error output” to store tha recrods in antother table you can get the ErrorCode and the ErrorColumn values for each failing record.
If you are using the fast load option in the dataflow, you’ll get the following error code for the failing records: -1071607685 and if you look it up you’ll get the informative error message ”No status is available”
By changing the Data Access Mode for the destination data flow task to: Table or View, you’ll get the correct error code and can investigate why the records are redirected.