TechNet
Export (0) Print
Expand All

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 managerOptions
    ADO Connection ManagerConfigure OLE DB Connection Manager
    ADO.NET Connection ManagerConfigure ADO.NET Connection Manager
    Analysis Services Connection ManagerAdd Analysis Services Connection Manager Dialog Box UI Reference
    Excel Connection ManagerExcel Connection Manager Editor
    File Connection ManagerFile Connection Manager Editor
    Multiple Files Connection ManagerAdd File Connection Manager Dialog Box UI Reference
    Flat File Connection ManagerFlat 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 ManagerMultiple 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 ManagerFTP Connection Manager Editor
    HTTP Connection ManagerHTTP Connection Manager Editor (Server Page)

     HTTP Connection Manager Editor (Proxy Page)
    MSMQ Connection ManagerMSMQ Connection Manager Editor
    ODBC Connection ManagerODBC Connection Manager UI Reference
    OLE DB Connection ManagerConfigure OLE DB Connection Manager
    SMO Connection ManagerSMO Connection Manager Editor
    SMTP Connection ManagerSMTP Connection Manager Editor
    SQL Server Compact Edition Connection ManagerSQL Server Compact Edition Connection Manager Editor (Connection Page)

     SQL Server Compact Edition Connection Manager Editor (All Page)
    WMI Connection ManagerWMI Connection Manager Editor
  5. To save the updated package, click Save Selected Items on the File menu.

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

Community Additions

ADD
Show:
© 2016 Microsoft