How to configure a new transformation for a Transform Data task (Enterprise Manager)

How to configure a new transformation for a Transform Data task (Enterprise Manager)

To configure a new transformation for a Transform Data Task

1. After configuring your source and destination connections, click the Transformations tab.
   
   
2. Do one of the following:
   • If the columns you want are not already mapped to another transformation, click New.
     
     
   • If the columns you want are already mapped, click on the mapping line for the transformation, click Delete, and then click New.
3. In the Create New Transformation dialog box, click the type of transformation you want to add. The Transformation Options dialog box is displayed.
   
   
4. Click the Source Columns tab, and then use the arrow buttons to select columns for the transformation.
   
   
5. Click the Destination Columns tab, and then use the arrow buttons to select columns for the transformation.
   
   
6. Click the General tab, click Properties, and then accept or edit the properties for the transformation you selected.
   
   
7. Repeat steps 2 through 6 for each transformation you want to create.

See Also

Mapping Column Transformations

DTS Transformations

Tasks That Transform Data

Transform Data Task