Data Driven Query Task Properties (Transformations Tab)

DTS Designer

DTS Designer Help

Data Driven Query Task Properties (Transformations Tab)

Use this tab to select and graphically map the source and binding columns composing each transformation. Graphically mapping a transformation is not required. Instead, you may specify the source and destination columns for a transformation using selection boxes in the Transformation Options dialog box.

Column mappings are represented on this tab by arrows connecting columns in the Source and Binding table boxes. By default, the Data Driven Query task maps an equal number of matched source and binding table columns using a single many-to-many mapping.

Important  Unless you are an advanced user or have specialized needs, you should not need to change the default column mappings for a Data Driven Query task.

Options

Phases filter

Select the data pump phase for which you want to add a transformation. This advanced option is only available if the Show multi-phase pump in DTS Designer check box is selected in SQL Server Enterprise Manager. The default is Row transform phase.

Name

View the name of the selected transformation. You must click on a mapping line to display the name of the transformation. Otherwise <none selected> is displayed. By default, the transformations are named DTS_Transformation_n, where n is equal to the ordinal position of the mapped transformation.

Type

View the type of column-level transformation for the selected mapping. You must click on a mapping line to display the transformation type. Otherwise <none selected> is displayed. If you intend to create a new transformation, this value is ignored.

New

Display the Create New Transform dialog box, where you select a type of column-level transformation.

Edit

Display the Transformation Options dialog box, where you can modify an existing transformation. Select the mapping line of the transformation you want to modify before clicking Edit.

Delete

Delete a selected transformation. Select the mapping line representing the transformation you want to remove from the task before clicking Delete.

Source

View the columns of the source data in graphical form, and click one or more columns to include in a transformation.

Binding table

View the columns of the binding table in graphical form, and click one or more columns to include in a transformation.

Select All

Select all source columns and all destination columns. Use Select All when you want to create a many-to-many type of transformation mapping.

Delete All

Delete all transformations. Select the mapping line representing the transformation you want to remove from the task before clicking Delete.

See Also

Mapping Column Transformations

Data Driven Query Task

Multiphase Data Pump Functionality