Using WMI Data Reader and WMI Event Watcher Tasks in SSIS

Tuesday Dec 22nd 2009 by DatabaseJournal.com Staff

Windows Management Instrumentation (WMI) Tasks within SSIS can be used by to read WMI data and to watch for WMI events.

[From SQL Server Performance]

SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article Using the Transfer Jobs Task in SQL Server Integration Services I discussed how to use the Transfer Job Task which is available in SQL Server 2005 Integration Services and later versions. In this article I will examine the use of the WMI Data Reader Task and WMI Event Watcher Task which is available in SQL Server 2005 and later versions.

The article continues at http://www.sql-server-performance.com/articles/dba/wni_data_reader_wmi_event_watcher_p1.aspx

Mobile Site | Full Site