Error Handling in SSIS05-12-2018 0 Comment(s)
errors might occur when we are extracting data from a source, or loading data into a destination, or when you are performing a transformation. This is because of the unexpected data, and it is a bad practice to fail the package.
To handle these situations, SSIS introduced the concept called Error Handling. In this article, we will show you, How to configure Error Handling in SSIS with an example.
For the demonstration purpose, we will Export data present in the Employee.xls to sql server database table, and configure error handling at Data Conversion. Below screenshot will show you the data present in the Employee Excel file
From the above screenshot, you can see that Occupation of EmpId 2, 13, 14 is larger than the length 255
Error Handling in SSIS Example
Drag and drop the data flow task from the toolbox to control flow and change the name as Error Handling in SSIS.
Double click on it will open data flow tab. Now, Drag and drop Excel Source, Data Conversion Transformation, OLE DB Destination from SSIS toolbox into the data flow region
Double click on Excel source will open the connection manager settings and provides an option to select the table holding the source data. Here, we are selecting the Employees.xls file present in the file system.
From the above screenshot, you can observe that we are selecting the Employee_Destination table present in the Employee.xls file
No Comments to Show