O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Querying system events: WMI Event Watcher Task

In the previous recipe, one of the most common scenarios was reading system information from WMI. SSIS provides another WMI Task named WMI Event Watcher Task, which is more useful than the Data Reader Task. WMI Event Watcher Task provides a way to watch for a WMI event. This awesome feature will make the SSIS package very powerful. As WMI provides extensive information for the management of objects, interaction with this information as events will be very useful. Scenarios such as watching a folder for new files or watching CPU for 50 percent usage are some of the most common scenarios that can be accomplished with this task.

In this recipe we will watch a folder for new files, and if a new file comes ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required