OLEDB destination redirectin rows to error output for no apparent reason

  • Hi,

    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?

    Thanks

  • Are there any errors or warnings?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Ciao my name is Mauro , i write from Italy.

    I have today the same problem you posted time ago in this site.

    Anyone could help you ???

    Did you find a solution or work around ???

    Me too i put data viewers adn i encontered the same error.

    Regards in advance.

    Ciao.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply