September 10, 2009 08:10 PM
Using a Variable to Store the WMI Data Reader Task's Output
Rating:
(0)
SQL Server Magazine
InstantDoc ID #102564
In SQL Server Integration Services (SSIS) packages, you can use WMI Data Reader tasks to obtain Windows Management Instrumentation (WMI) data from computers. In "Use SSIS to Access WMI Data on Multiple Servers," this data is stored in a file. Alternatively, you can store it in a variable.
The 102564.zip file includes an SSIS package—WMICollectDrivesInfo_Var.dtsx—that uses a variable named WMIOut to store the WMI Data Reader task's output. To obtain the 102564.zip file, click the 102564.zip hotlink at the top of the page.
To cre...
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: