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.

To add a connection manager to a package

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.

See Also

Tasks

How to: Add a Data Source Reference to a Package
How to: Modify a Connection Manager
How to: Delete a Connection Manager in a Package

Concepts

Connection Managers
Connection Manager How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance