Average: 3.5 (2 votes)


Overview

Data flow source, loading data from Windows Management Information (WMI).


Setup

The script has the following parameters:

  • Connection - selects WMI connection.
  • IsQueryVariable - indicates whether the query is stored in variable.
    • Query - specifies WMI Query Language (WQL) statement.
    • QueryVariable - selects variable containing WQL statement.

Requirements

Depends on COZYROC Script Component Plus for implementing parameters user interface.


Library references

  • System
  • System.Data
  • Microsoft.SqlServer.TxScript
  • Microsoft.SqlServer.PipelineHost
  • Microsoft.SqlServer.DTSPipelineWrap
  • Microsoft.SqlServer.DTSRuntimeWrap
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus
  • System.Management

ScriptMain