OLEDB destination redirectin rows to error output for no apparent reason

• sameera33

  SSC Enthusiast

  Points: 152

  More actions

  February 28, 2011 at 1:53 pm

  #157463

  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

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  March 1, 2011 at 3:48 am

  #1292797

  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

• maretix

  Hall of Fame

  Points: 3835

  More actions

  October 25, 2012 at 11:11 am

  #1552824

  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.