How to: Create an Event Handler Using SSIS Designer

A package can include event handlers that respond to the events that executables raise. For more information about executables, see Integration Services Packages, Integration Services Tasks and Integration Services Containers.

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. For more information, see Creating Package Control Flow.

  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. For more information, see Creating Package Data Flow.

  9. On the File menu, click Save Selected Items to save the package.

See Also

Tasks

Creating Package Event Handlers

Concepts

Integration Services Event Handlers
Event Handler How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance