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
     

No comments:

Post a Comment