Event Handler Using SSIS Designer

To create an event handler

1. In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.
2. In Solution Explorer, double-click the package to open it.
3. Click the Event Handlers tab.
4. In the Executables list, select the executable for which you want to create an event handler.
5. In the Event handler list, select the event handler you want to build.
6. Click the link on the design surface of the Event Handler tab.
7. Add control flow items to the event handler, and connect items using a precedence constraint by dragging the constraint from one control flow item to another.
8. Optionally, add a Data Flow task, and on the design surface of the Data Flow tab, create a data flow for the event handler.
9. On the File menu, click Save Selected Items to save the package.

OnError	The event handler for the OnError event. This event is raised by an executable when an error occurs.
OnExecStatusChanged	The event handler for the OnExecStatusChanged event. This event is raised by an executable when its execution status changes.
OnInformation	The event handler for the OnInformation event. This event is raised during the validation and execution of an executable to report information. This event conveys information only, no errors or warnings.
OnPostExecute	The event handler for the OnPostExecute event. This event is raised by an executable immediately after it has finished running.
OnPostValidate	The event handler for the OnPostValidate event. This event is raised by an executable when its validation is finished.
OnPreExecute	The event handler for the OnPreExecute event. This event is raised by an executable immediately before it runs.
OnPreValidate	The event handler for the OnPreValidate event. This event is raised by an executable when its validation starts.
OnProgress	The event handler for the OnProgress event. This event is raised by an executable when measurable progress is made by the executable.
OnQueryCancel	The event handler for the OnQueryCancel event. This event is raised by an executable to determine whether it should stop running.
OnTaskFailed	The event handler for the OnTaskFailed event. This event is raised by a task when it fails.
OnVariableValueChanged	The event handler for the OnVariableValueChanged event. This event is raised by an executable when the value of a variable changes. The event is raised by the executable on which the variable is defined. This event is not raised if you set the RaiseChangeEvent property for the variable to False. For more information, see Integration Services Variables.
OnWarning	The event handler for the OnWarning event. This event is raised by an executable when a warning occurs.