To rename a connectionConnect to a data source by selecting a provider on the Data menu or dragging its icon from the Data section of the tool palette, and filling in its properties.
You can either configure a new connection or use an existing one. You can have multiple data sources that use the same connection.
The properties displayed depend on whether the connection is defined as:
The properties for each connection vary depending on the individual provider; for example, the Microsoft OLE DB Provider for Jet requires a server name, username, and password. The Microsoft OLE DB Provider for SQL Server requires an authentication mode and a database name. A Microsoft Data Link connection requires either loading a data link file (.udl file) or setting the data link file properties for an OLE DB provider.
After you have created a data source connection on the DTS Designer workspace, you can select it and then view or modify its properties.
If you are creating a new data source connection, enter the required property information. You can copy the connection properties of an existing connection by viewing its properties, then selecting New connection. If you are working with an existing connection, then the data source and its properties, and the advanced properties, are read-only.
If you are specifying a file connection, you must specify the format of the file. DTS Designer reuses the file format pages of the DTS Import and DTS Export wizards to perform this operation.
When specifying a file format for a file connection, specify:
Microsoft Data Link connections provide a method of connecting through an OLE DB provider and saving the connection information.
If you are specifying a data link connection, you must first specify whether to load an existing data link (.udl) file or to create a data link to save with DTS Designer.
If you want to use a data link file rather than saving the data link with DTS Designer, you can create one either from Windows Explorer or during the data link configuration process in DTS Designer.
If you edit a package and change the connection properties, DTS Designer attempts to connect to the server you specify. If that server is currently unavailable, DTS Designer will not allow you to change the connection properties.
When a package is executing, DTS does not validate the connections and only connects when necessary. This behavior allows you to set the connection properties dynamically with an ActiveX script (for example, selecting a server) before making the actual connections.
If there are transformations defined between two connections, and you want to change either the source or destination connection, your transformations may no longer be valid; therefore, DTS Designer prompts you as to whether you want to reset the transformation properties to their defaults. If you decide to reset the transformation, the properties of every transformation associated with the connection are deleted (however, any lookups will not be affected).
You rename an instance of an existing connection on the DTS Designer work space by creating a new connection, based on the existing connection. If the package contains additional instances of the old connection, you may need to modify them as well.
To rename a connection
