Handling Events at Package Run-time
When the packages are executed, variables change values, and data flows from files to tables and gets transformed along the way by various tasks. These tasks and processes come across changing data and environments at run-time, which sometimes results in alerts or events being raised. In such situations, you may wish to be present at run-time so that you can sort out events raised by the tasks. Integration Services comes to the rescue by providing event handlers that can act as your agents and be present at the runtime configured to respond to events and add intelligence to the packages by properly handling the events raised.
As containers have subcontainers, so do packages have event handlers. Event handlers ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
