Export (0) Print
Expand All

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

  1. In Business Intelligence Development Studio, 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 Business Intelligence Development Studio, 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

    Excel Connection Manager

    Excel Connection Manager Editor

    File Connection Manager

    File Connection Manager Editor

    Multiple Files Connection Manager

    Add File Connection Manager

    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

    Configure ODBC Connection Manager

    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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft