Transform Data Task Properties (Transformations Tab)
Use this tab to select and graphically map the source and destination columns composing each transformation. Graphically mapping a transformation is not required. You can also map transformations using selection boxes in the Transformation Options dialog box.
Column mappings are represented on this tab by arrows connecting columns in the Source and Destination boxes. By default, the Transform Data task maps all columns using one-to-one column mappings.
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 the Package Properties dialog box. 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 type of the transformation; otherwise <none selected> is displayed. If you intend to create a new transformation, the value is ignored.
New
Display the Create New Transform dialog box, where you can 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.
Destination
View the columns of the destination data in graphical form, and click one or more columns to include in a transformation.
Test
Run the selected transformation. Select the mapping line representing the transformation you want to run before clicking Test. The results of the transformation are sent to a text file, and you can view the data. No permanent changes to the destination data are made when you test 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.