Monday, December 18, 2006

SSIS Event Handlers

One of the reason to call SSIS as an enterprise class ETL tool is becuase SSIS supports Event Handlers. Event Handlers of SSIS are very much similar to event handlers provided in any modern languages like C# and Java. With the help of event handlers in SSIS, we can develop packages which can take necessary actions on specific events. Event handlers allow package to react to specific states of a package execution. Say for example, we can log information about the environment and its state when a package fails . We can send an e-mail on every successful execution of a task .

To know more about event handlers read the articles SQL Server 2005 - SQL Server Integration Services - Part 11 - SSIS Events and Event Handlers, Custom Logging Using Event Handlers