You can change connection information at any time. When you edit a connection object, the Integration Service uses the updated connection information the next time the session runs.
Open the Connection Browser dialog box for the connection object. For example, click Connections > Relational to open the Connection Browser dialog box for a relational database connection.
Click Edit.
The Connection Object Definition dialog box appears.
Enter the values for the properties you want to modify.
The connection properties vary depending on the type of connection you select. For more information about connection properties, see the section for each specific connection type in this chapter.