Error Handling in SSIS

1. Create control flow by using the control flow designer.
2. Configure transaction handling for packages, containers, and tasks.
1. Enable Distributed Transaction Coordinator (DTC)
2. Lock windows from view menu
3. Set transaction option
3. Set checkpoints to define restart points.
1. Set checkpoint properties to TRUE
2. CheckpointFilename property provide Valid path for check point file
3. CheckpointUsage to IfExists
4. Create event handlers.
5. Implement error handling. (error redirection)
1. Handle errors by configuring data flow paths.
2. Handle errors by configuring control flow paths.
6. Debug packages.
1. Debug progress reporting.
2. View intermediate results by using debug windows.
3. Examine the package state by setting breakpoints.