How to: Add a Connection Manager to a Package

SQL Server 2005 Integration Services (SSIS) includes a variety of connection manager types for connecting to different data sources, such as relational databases, Analysis Services databases, and files in CSV and XML formats. This procedure applies to all connection manager types.

  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 anywhere in the Connection Managers area, and then do one of the following:

    • Click the connection manager type to add to the package.
    • If the type that you want to add is not listed, click New Connection to open the Add SSIS Connection Manager dialog box, select a connection manager type, and then click OK.
  5. The custom dialog box for the selected connection manager type opens. For more information about connection manager types and the options that are available, see the following options 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

  6. The Connection Managers area lists the added connection manager.

  7. Optionally, right-click the connection manager, click Rename, and then modify the default name of the connection manager.

  8. To save the updated package, click Save Selected Item on the File menu.

Community Additions

ADD
Show: