Sunday, 16 October 2011

SSIS : Redirecting Error Rows



  1. Set the Connection manager for the Data Source
  2. Set the Option of redirection in the Error Output Page of the Source Editor 
  3.  Create a table for the Error Rows (Not necessarily SQL) 
  4.  Configure a Data Destination for the error rows   
  5. Done Execute the package and the data with error goes to the Error Destination
     

1 comment:

  1. I just wanna say thank you for sharing the content and wish you all the best for your website and your whole team.

    Count
    www.imarksweb.org

    ReplyDelete