How to create a Transform Data task (Enterprise Manager)

How to create a Transform Data task (Enterprise Manager)

To create a Transform Data Task

1. On the Data Transformation Services (DTS) Designer design sheet, click the connection you want to use as a source, and then CTRL-click the connection you want to use as a destination.

   You must have your source and destination connections defined before configuring a Transform Data task.

2. From the Task toolbar, drag a Transform Data task to the design sheet.

See Also

DTS Connections

Tasks That Transform Data

Transform Data Task