Error handling in SSIS package
I am new to error handling in SSIS. What should I use package level, task level error handling....? I want to capture following information while loading data from CSV to sql table: 1. SSIS package start time 2. Data validation like input data is not in correct formart or duplicate 3. Database SQL (insert operation) error 4. SSIS package End Time Can anyone please suggest how to proceed on this.SandyLeo
October 20th, 2010 8:14pm
This sounds more like capturing faulty data than actual Error Handling. In your Data Flow, for the OLE DB Destination, set the Table Access Mode to "Table or View". Now drag the red arrow from the bottom of the Destination and drop it onto a new Flat File Destination. Configure the flat file to take all the columns, and configure the Error Configuraiton on the OLE DB Destination to "Redirect Rows". Note that you may need to add a couple of columns to the pipe line, which you can do with a Derived Column transform.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
October 20th, 2010 9:40pm
Hello, Here is good link to learn , package logging http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx Thanks
October 20th, 2010 10:07pm