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.
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.
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.
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.
Display the Create New Transform dialog box, where you select a type of column-level transformation.
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 a selected transformation. Select the mapping line representing the transformation you want to remove from the task before clicking Delete.
View the columns of the source data in graphical form, and click one or more columns to include in a transformation.
View the columns of the binding table in graphical form, and click one or more columns to include in a transformation.
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 transformations. Select the mapping line representing the transformation you want to remove from the task before clicking Delete.