Error Handling in SSIS

Errors can occur frequently because of unexpected data values. But many data flow components support error outputs which let you control how the component handles row level errors in both incoming and outgoing data. So there are 3 actions that are available when an error occurs:

1. Ignore Failure- If an error occurs, SSIS ignores the error and moves ahead.

2. Redirect Row- If error occurs, SSIS moves those bad records to a different destination and correct records to the actual destinations.

3. Fail Component- Default component being used in SSIS, which fails the package if there is any error.