- Set the Connection manager for the Data Source
- Set the Option of redirection in the Error Output Page of the Source Editor
- Create a table for the Error Rows (Not necessarily SQL)
- Configure a Data Destination for the error rows
- Done Execute the package and the data with error goes to the Error Destination
No comments:
Post a Comment