How to rename a connection (DTS Designer)

To rename an instance of a connection in DTS Designer:

1. Right-click the connection you want and click Properties.
2. In the Connection Properties dialog box, click New connection.
3. Enter the new name and click OK.
4. When you are prompted to reset the transformation associated with the connection, click No.

To rename additional instances of the old connection:

1. Right-click each additional connection you want to rename and click Properties.
2. In the Connection Properties dialog box, click Existing connection, then select the new name from the list and click OK.
3. When you are prompted to reset the transformation associated with the connection, click No.