Set the Properties of a Connection Manager

 

Applies To: SQL Server 2016

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

1. In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want.

2. In Solution Explorer, double-click the package to open it.

3. In SSIS Designer, click the Control Flow tab, the Data Flow tab, or the Event Handler tab to make the Connection Managers area available.

4. Right-click the connection manager and click Properties.

5. 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.

6. Click OK.

7. To save the updated package, click Save Selected Items on the File menu.

To modify a connection manager using a connection manager dialog box

1. In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want.

2. In Solution Explorer, double-click the package to open it.

3. In SSIS Designer, click the Control Flow tab, the Data Flow tab, or the Event Handler tab to make the Connection Managers area available.

4. 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.

   Connection manager	Options
   ADO Connection Manager	Configure OLE DB Connection Manager
   ADO.NET Connection Manager	Configure ADO.NET Connection Manager
   Analysis Services Connection Manager	Add Analysis Services Connection Manager Dialog Box UI Reference
   Excel Connection Manager	Excel Connection Manager Editor
   File Connection Manager	File Connection Manager Editor
   Multiple Files Connection Manager	Add File Connection Manager Dialog Box UI Reference
   Flat File Connection Manager	Flat File Connection Manager Editor (General Page)  Flat File Connection Manager Editor (Columns Page)  Flat File Connection Manager Editor (Advanced Page)  Flat File Connection Manager Editor (Preview Page)
   Multiple Flat Files Connection Manager	Multiple Flat Files Connection Manager Editor (General Page)  Multiple Flat Files Connection Manager Editor (Columns Page)  Multiple Flat Files Connection Manager Editor (Advanced Page)  Multiple Flat Files Connection Manager Editor (Preview Page)
   FTP Connection Manager	FTP Connection Manager Editor
   HTTP Connection Manager	HTTP Connection Manager Editor (Server Page)  HTTP Connection Manager Editor (Proxy Page)
   MSMQ Connection Manager	MSMQ Connection Manager Editor
   ODBC Connection Manager	ODBC Connection Manager UI Reference
   OLE DB Connection Manager	Configure OLE DB Connection Manager
   SMO Connection Manager	SMO Connection Manager Editor
   SMTP Connection Manager	SMTP Connection Manager Editor
   SQL Server Compact Edition Connection Manager	SQL Server Compact Edition Connection Manager Editor (Connection Page)  SQL Server Compact Edition Connection Manager Editor (All Page)
   WMI Connection Manager	WMI Connection Manager Editor

5. To save the updated package, click Save Selected Items on the File menu.

See Also

Integration Services (SSIS) Connections
Add, Delete, or Share a Connection Manager in a Package