SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Integration Services
Technical Reference
Feature Reference
Integration Services F1 Help
SSIS Designer F1 Help
Task Properties UI Reference
ActiveX Script Task Editor (General Page)
ActiveX Script Task Editor (Script Page)
Analysis Services Execute DDL Task Editor (General Page)
Analysis Services Execute DDL Task Editor (DDL Page)
Analysis Services Processing Task Editor (General Page)
Analysis Services Processing Task Editor (Analysis Services Page)
Bulk Insert Task Editor (General Page)
Bulk Insert Task Editor (Connection Page)
Bulk Insert Task Editor (Options Page)
Data Mining Query Task Editor (Mining Model Tab)
Data Mining Query Task Editor (Query Tab)
Data Mining Query Task Editor (Output Tab)
Data Profiling Task Editor (General Page)
Single Table Quick Profile Form (Data Profiling Task)
Data Profiling Task Editor (Profile Requests Page)
Destination Database Files
Execute DTS 2000 Package Task Editor (General Page)
Execute DTS 2000 Package Task Editor (Inner Variables Page)
Execute DTS 2000 Package Task Editor (Outer Variables Page)
Execute Package Task Editor (General Page)
Execute Package Task Editor (Package Page)
Execute Process Task Editor (General Page)
Execute Process Task Editor (Process Page)
Execute SQL Task Editor (General Page)
Execute SQL Task Editor (Parameter Mapping Page)
Execute SQL Task Editor (Result Set Page)
File System Task Editor (General Page)
FTP Task Editor (General Page)
FTP Task Editor (File Transfer Page)
Message Queue Task Editor (General Page)
Message Queue Task Editor (Receive Page)
Message Queue Task Editor (Send Page)
Script Task Editor (General Page)
Script Task Editor (Script Page)
Select Objects to Transfer
Select Variables Page
Send Mail Task Editor (General Page)
Send Mail Task Editor (Mail Page)
Source database files
Transfer Database Task Editor (General Page)
Transfer Database Task Editor (Databases Page)
Transfer Error Messages Task Editor (General Page)
Transfer Error Messages Task Editor (Messages Page)
Transfer Jobs Task Editor (General Page)
Transfer Jobs Task Editor (Jobs Page)
Transfer Logins Task Editor (General Page)
Transfer Logins Task Editor (Logins Page)
Transfer SQL Server Objects Task Editor (General Page)
Transfer SQL Server Objects Task Editor (Objects Page)
Transfer Master Stored Procedures Task Editor (General Page)
Transfer Master Stored Procedures Task Editor (Stored Procedures Page)
Web Service Task Editor (General Page)
Web Service Task Editor (Input Page)
Web Service Task Editor (Output Page)
WMI Data Reader Task Editor (General Page)
WMI Data Reader Task Editor (WMI Options Page)
WMI Event Watcher Task Editor (General Page)
WMI Event Watcher Task Editor (WMI Options Page)
XML Task Editor (General Page)
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

WMI Data Reader Task Editor (WMI Options Page)

SQL Server 2008 R2

Use the WMI Options page of the WMI Data Reader Task Editor dialog box to specify the source of the Windows Management Instrumentation Query Language (WQL) query and the destination of the query result.

To learn about this task, see WMI Data Reader Task. For more information about WMI Query Language (WQL), see the Windows Management Instrumentation topic, Querying with WQL, in the MSDN Library.

WMIConnectionName

Select a WMI connection manager in the list, or click <New WMI Connection…> to create a new connection manager.

Related Topics: WMI Connection Manager, WMI Connection Manager Editor

WQLQuerySourceType

Select the source type of the WQL query that the task runs. This property has the options listed in the following table.

Value

Description

Direct input

Set the source to a WQL query. Selecting this value displays the dynamic option WQLQuerySourceType.

File connection

Select a file that contains the WQL query. Selecting this value displays the dynamic option WQLQuerySourceType.

Variable

Set the source to a variable that defines the WQL query. Selecting this value displays the dynamic option WQLQuerySourceType.

OutputType

Specify whether the output should be a data table, property value, or property name and value.

OverwriteDestination

Specifies whether to keep, overwrite, or append to the original data in the destination file or variable.

DestinationType

Select the destination type of the WQL query that the task runs. This property has the options listed in the following table.

Value

Description

File connection

Select a file to save the results of the WQL query in. Selecting this value displays the dynamic option, DestinationType.

Variable

Set the variable to store the results of the WQL query in. Selecting this value displays the dynamic option, DestinationType.

WQLQuerySourceType = Direct input

WQLQuerySource

Provide a query, or click the ellipsis (…) and enter a query using the WQL Query dialog box.

WQLQuerySourceType = File connection

WQLQuerySource

Select a File connection manager in the list, or click <New connection...> to create a new connection manager.

Related Topics: File Connection Manager, File Connection Manager Editor

WQLQuerySourceType = Variable

WQLQuerySource

Select a variable in the list, or click <New variable...> to create a new variable.

Related Topics: Integration Services Variables, Add Variable

DestinationType = File connection

Destination

Select a File connection manager in the list, or click <New connection...> to create a new connection manager.

Related Topics: File Connection Manager, File Connection Manager Editor

DestinationType = Variable

Destination

Select a variable in the list, or click <New variable...> to create a new variable.

Related Topics: Integration Services Variables, Add Variable

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.