How to configure the connections for a Transform Data task (Enterprise Manager)

To configure the connections for a Transform Data task

1. Point to the Transform Data task on the Data Transformation Services (DTS) Designer design sheet until the cursor changes, and then double-click to open the Transform Data Task Properties dialog box.
   
   
2. On the Source tab, type a description for the task.
   
   
3. Under Connection, do one of the following:
   • Click Table / View and select a table or view from the list.
     
     
   • Click SQL query. You can enter the query text in the box or click Build Query to create the query with DTS Query Designer. If you create a query with input parameters, click Parameters to assign the parameters to DTS package global variables.
4. Click the Destination tab, and then do one of the following:
   • In the Table name list, select a destination table.
     
     
   • Create a new table by clicking Create and editing the CREATE TABLE script in the Create Destination Table dialog box.

See Also

DTS Connections

DTS Transformations

Tasks That Transform Data

Transform Data Task