Error Redirection with the OLE DB Destination

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 28, 2012 at 1:01 pm

  #145542

  Hi.

  I'm looking for some good articles on Error Flow redirection in SSIS.

  I have found some but they were not very detailed.

  I'm looking for directions to include screen shots.

  I want to have one table to include the offending table and schema, source system, etc so that I can identify each offending row without any duplication or rows that were rejected because of the batch size.

  I read that can get duplicates if you specify a fast load?

  Any ideas would be greatly appreciated.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 28, 2012 at 5:21 pm

  #1518896

  Comments on the following article?

  http://agilebi.com/jwelch/2008/09/05/error-redirection-with-the-ole-db-destination/

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/