After adding a connection, the Connection Settings dialog box opens
to allow you to optionally name your connection, change connection options,
and add scripts to run before or after running the DTS.
The Connection Settings dialog box contains the following
tabs:
Global Connection Settings — Display connection settings that are known in any other DTS that uses this connection. These settings include the connection name, the connection definition, and connection parameters.
DTS Connection Settings — Display connection settings that are only used in the current DTS. These settings include the connection description, adapter-specific settings, and any SQL scripts to run before or after the DTS runs.
When you are done making changes to the connection settings, click OK to close the dialog box and return
to the Connection Manager.