Transform Data Task Properties (Transformations Tab)

DTS Designer

DTS Designer Help

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.

See Also

Mapping Column Transformations

Tasks That Transform Data

Transform Data Task

Multiphase Data Pump Functionality