Data Driven Query Task Properties (Source Tab)

DTS Designer

DTS Designer Help

Data Driven Query Task Properties (Source Tab)

Use this tab to select a table or view, or the results of a query as a data source for the data driven queries.

Options

Description

Type a description of this Data Driven Query task.

Connection

Select an existing connection to a data source from the list.

Table/View

Select a table or view from the data source specified on the connection. There is no guaranteed ordering of rows.

SQL query

Specify that an SQL statement retrieves the data from the data source. Type the SQL statement.

Parameters

Map global variables to input parameters. This option can only be performed after specifying an SQL query that includes parameters (using one or more question marks as a parameter placeholders).

Preview

View the data in the selected source table or view.

Note  If your source connection is a dBase data source and you specify an SQL query, the source data may not be available for viewing.

Build query

Use the Data Transformation Services (DTS) Query Designer to create the SQL statement to execute against the data source.

Browse

Specify the location of an SQL query to execute.

Parse query

Check the syntax of the SQL statement prior to execution.

See Also

Data Driven Query Task

Using Parameterized Queries in DTS