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.

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.

See Also

Building a Data Driven Query

Data Driven Query Example: Changing Customer Accounts

Show:
© 2015 Microsoft