You are here:

Modifying Connection Settings

You can modify connection settings at any time.

If you open a DTS file for which a connection to a data source has been lost, the problem connection appears in red in the Connection Manager. To reestablish the connection, double-click the red connection and click the Global Connection Settings tab.

Note:

If the name of an existing connection is changed in a DTS, the updated name is only written to the database when that DTS is saved. Other DTS files that use that connection only display the updated connection name after the DTS is saved.

For more information, see Renaming Connections.

In the Workbench, click View > Connections. The Connection Manager appears.
Select the connection you want to change and click Edit. The Connection Settings dialog box opens.
On the Global Connection Settings tab, modify the connection attributes saved with the connection and that are available to all DTS files:
Note: Any changes you make on this tab affect other DTS files that use the modified connection.
1. If you want to modify the connection name, in Connection Name, change the string that identifies the connection. Connection names can be up to 32 characters long.
2. If you do not want to use the ksync* tables in the Scribe adapter, select the Ignore Scribe metadata tables (ksync*) within the selected data source option.
3. If you want to use the data source field labels as the field names, select the Use application labels as field names option. This option provides more user-friendly labels for users who are not familiar with the data source native field names.
4. If the adapter supports Unicode data, select the Support Unicode data option.
If you want to modify connection properties that are part of the current DTS, click Connect. The label changes depending on the connection selected in the Connection Manager:
- Connect — No connection is currently defined. Clicking this button opens the Connection Information dialog box where you can define a connection.
- Change Connection — A connection is defined and assigned a role within the DTS.
Depending on the original data source, the appropriate dialog box appears to allow you to make changes. For more information, see Adding a Connection.
Click the DTS Connection Settings tab. This tab enables you to modify the connection attributes that are saved in the current DTS.
If you want to modify the adapter-specific settings for the current connection, click Adapter Settings. Click OK when you have finished modifying the adapter settings.
Note: For information about the Adapter settings, see the online Help for your adapter.
If you want to force users to enter connection information when the DTS file next opens, select the Prompt for reconnect when opening this DTS option. Select this option if this DTS file is opened in another environment and you do not know the new connection information.
If this connection is used in a series of chained DTS files, select the Keep this connection open if it was used in the previous DTS option to cache connection information and save time when opening subsequent DTS files.
When you have made all the necessary changes, click OK. If you modified any connection settings, you are prompted to save your changes in connections that are used in other DTS files. Click one of the following:
- Yes — Save global changes you made to the existing connection, and specify the other DTS files using this connection that should be updated.
- No — Create a new connection with the properties you specified. This connection is also available to any DTS on your system, but no other DTS is updated to this connection.