Redirect Rows to one Table SSIS

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  August 10, 2012 at 11:48 am

  #151044

  I'm looking for a solution in which if there is an error I can redirect an error to a single table.

  If this is not easy or feasible then I would be happy if anyone could share any good articles on Redirection with pictures that complement the explanation.

  Any help 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/

• prvmine

  SSCertifiable

  Points: 7007

  More actions

  August 10, 2012 at 5:59 pm

  #1524719

  these might help

  http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e26dc7ab-fe49-4339-b8dd-5640db2b96e3/

  http://www.mssqltips.com/sqlservertip/1967/how-to-serialize-error-logging-in-ssis/