Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.