How to configure the connections for a Transform Data task (Enterprise Manager)
To configure the connections for a Transform Data task
- 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.
- On the Source tab, type a description for the task.
- 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.
- Click Table / View and select a table or view from the list.
- 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.
- In the Table name list, select a destination table.