If you change a target connection to a connection whose data objects match those of the original target connection, all links are preserved. References, such as rejected rows and key cross references, are updated to the new target connection.
Note: If you change a target connection to a connection whose data objects do not match those of the original target connection, all links to the original target connection are removed. You are prompted to change connection references in the DTS, such as rejected rows or the key cross-reference, from the original target connection to the new target connection.
In the Workbench, click Configure
Steps. The Configure Steps dialog box appears.
the Data Objects tab.
Do one of the following to change a target connection:
Modify Target Connection
Add an existing connection as a target
Click the Add button. The Add Target Connection dialog box appears.
From the Connection drop-down
menu, select a target connection.
Modify settings of a connection
Select the connection you want to modify.
Click the Edit button. The Connection Settings dialog box appears.