This is in SSIS 2008.
I have a package that inserts rows to an sql server table. The destination table has a composite primary key.
The OLEDB destination is configured to redirect rows to the error output.
Upon inspecting the rows that are redirected to the error output, it seems that some rows are redirected for no apparent reason.
A data viewer grid is used to inspect the exact error code in the error output path, the error code appended to the rows is -1071607685
and the error code description = No status available.
If the dataset is restricted to a very small number of rows, the problem goes away and the same rows that were redirected are inserted in the destination table.
Has anyone experienced this issue?