How to create a Transform Data task (Enterprise Manager)
To create a Transform Data Task
- 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.
- From the Task toolbar, drag a Transform Data task to the design sheet.