Set the Properties of a Connection Manager

  • Article

 

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