WMI implementation in SSIS

By : Kasim Wirama, MCDBA, MVP SQL Server
What is WMI? WMI stands for Windows Management Instrumentation. WMI is in query scripting language that is capable of managing your windows server and workstation. SSIS task for reading information in your workstation or server is provided by WMI data reader. For example to look information of your application log.
With WMI data reader, you can :
1. Read event log
2. Query list of running application
3. Query memory available for executing your SSIS package.
4. Get information of hard disk free space.
For example to get information of free disk space on c drive, you issue : SELECT FreeSpace, DeviceId, Size, SystemName, Description FROM Win32_LogicalDisk WHERE DeviceID = 'C:' or you want to get information about SSIS service and package running you issue : SELECT * FROM Win32_NTLogEvent WHERE LogFile = 'Application' AND (SourceName='SQLISService' OR SourceName='SQLISPackage').
WMI data reader task need WMI type connection manager. On task editor of the task, you specify whether you specify your query directly or through file/variable in WsqlQuerySourceType and specify the query itself in WsqlQueryType, and what kind of output format you would like to get, tabular format or property name – value format or just value format at Output type property. Destination type property gives you options whether you would like to save the output into file or variable, if you want to see the result directly without further processing, you can select the output to file.
Run your package, WMI reader task will read information through WMI query you specify.