Export (0) Print
Expand All
Expand Minimize

Data Driven Query Task Properties (Queries Tab)

SQL Server 2000

Use this tab to query and set the properties of the source rowset.


Query Type

Select the type of data driven query to execute. Options include Insert, Update, Delete, or User (stored procedure).

The query type labels are suggestions only. You can use a Query Type of Insert to perform an Update, a Query Type of Delete to perform an Insert, and so on. For readability, you may want to use the label that matches the type of query you plan to use.


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

Parse/Show Parameters

Check the syntax of the SQL statement and list any parameters mapped to binding columns on the Transformations tab.


Indicate the binding column for a mapped parameter.


Indicate the corresponding parameter mapped to a binding column.

See Also

Building a Data Driven Query

Data Driven Query Example: Changing Customer Accounts

© 2015 Microsoft