WMI Event Watcher Task
Using the WMI Event Watcher task, you can configure your SSIS package to watch for an event, and based on the event occurrence decide whether to run the package or raise an alert using underlying WMI technology. This is a powerful feature though it requires your skills to write WQL event queries to specify the events you want to watch for. You can use this task in situations such as the following:
To check for availability of enough resources (disk space, memory, and so on) on the computer system before running the package.
To watch for files being added to a folder before starting the package.
To wait for an e-mail (from another package) to arrive with particular subject before initiating the processing of the SSIS package. ...
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.
