Error handling in SSIS

There are five way to do Error handling.

1. Event handler
2. Error redirection
3. Event Log or Error Log
4. Checkpoint usage
5. Transactions

1. Event Handler: Event handler is about when event occurs it may be OnError, OnExecStatusChanged, OnInformation, OnPostExecute, OnPostVaildate, OnPreExecute, OnPreVaildate, OnProgress, OnQueryCancel, OnTaskFailed, OnvariableValueChanged or OnWarning.
2. Error Redirection: Error Redirection is like when ever error occurs you can create precedence constraint connection which may be at control flow or data flow level. 
3. Event Log or Error Log: Event log may occur at any level pre execute, post execute, on error, on validation. There are 5 different way to do event log. Text file, SQL Server, SQL Server Profiler, Windows event log and XML files.
4. Check point: Check point is like a failure point. While running the package if execution process got failed than on next run it will start from failure point. It uses checkpoint file to keep track for last run.
5. Transactions: Transactions are created using same concept as we have for T-SQL. But purpose is quite different. There are basic three types of transactions. Required, Supported and Not Supported. By default it is supported. 

We will have more discussion but this one is overview of how we can do error handling using SSIS.