Data Driven Query Task Properties (Queries Tab)
Use this tab to query and set the properties of the source rowset.
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.
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.