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 information: WMI Data Reader Task

WMI stands for Windows Management Instrumentation and this Task provides easy access to information form the management objects of Windows-based operating systems. For example: the number of hard drivers, CPU usage statistics, a list of running processes, and any other information can be fetched with WMI. We use a language named WQL to fetch information from WMI, which is a query language for WMI.

As WMI provides extensive access to management information for our system and the operating system, SSIS provides two tasks for WMI. In this recipe, we take a look at the WMI Data Reader Task and read the running processes' information and load its data into a file.

Getting ready

Create an empty destination ...

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