Export (0) Print
Expand All
Expand Minimize

Data Driven Query Task Properties (Bindings Tab)

SQL Server 2000

Use this tab to configure the bindings to which the parameters of the data driven queries will map. If you intend to use multiple queries in a Data Driven Query task, the binding table must include columns for all parameters in the queries.

Options

Connection

Select an existing data source connection to use as the basis for the parameter binding table.

Table name

Select an existing table to use for the parameter bindings. Make sure the table includes columns for all parameters in the queries you will define.

Create

Create a new binding table to use for the parameters. A binding table must exist before you can specify transformations.

Name

View the column name.

Type

View the destination native data type using OLE DB data type mappings.

Nullability

View whether binding columns allow null values. The default is true.

Size

View the width of binding columns where applicable.

Precision

View the precision of binding columns where applicable.

Scale

View the number of digits in scale where applicable.

See Also

Data Driven Query Task

Show:
© 2015 Microsoft