Data Driven Query Task Properties (Bindings Tab)

DTS Designer

DTS Designer Help

Data Driven Query Task Properties (Bindings Tab)

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