How to: Set the Properties of a Connection Manager
All connection managers can be configured using the Properties window.
Integration Services also provides custom dialog boxes for modifying the different types of connection managers in Integration Services. The dialog box has a different set of options depending on the connection manager type.
To modify a connection manager using the Properties window
In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.
In Solution Explorer, double-click the package to open it.
In SSIS Designer, click the Control Flow tab, the Data Flow tab, or the Event Handler tab to make the Connection Managers area available.
Right-click the connection manager and click Properties.
In the Properties window, edit the property values. The Properties window provides access to some properties that are not configurable in the standard editor for a connection manager.
Click OK.
To save the updated package, click Save Selected Items on the File menu.
To modify a connection manager using a connection manager dialog box
In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.
In Solution Explorer, double-click the package to open it.
In SSIS Designer, click the Control Flow tab, the Data Flow tab, or the Event Handler tab to make the Connection Managers area available.
In the Connection Managers area, double-click the connection manager to open the Connection Manager dialog box. For information about specific connection manager types, and the options available for each type, see the following table.
To save the updated package, click Save Selected Items on the File menu.