Data Driven Query Task Properties (Queries Tab)
Use this tab to query and set the properties of the source rowset.
Options
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.
Build
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.
Destination
Indicate the binding column for a mapped parameter.
Parameters
Indicate the corresponding parameter mapped to a binding column.