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.