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.