How to: Add or Delete a Connection Manager in a Package
Integration Services includes a variety of connection managers for connecting to different data sources, such as relational databases, Analysis Services databases, and files in CSV and XML formats.
The following procedures apply to all types of connection managers and describe how to do the following tasks:
Use a wizard to add a connection manager during package creation.
Add a connection manager to an existing package.
Delete a connection manager from a package.
To add a connection manager when creating a package
Use either the the SQL Server Import and Export Wizard or Integration Services Connection Project Wizard.
In addition to creating and configuring a connection manager, these wizards also help you create and configure the sources and destinations that use the connection manager. For more information, see Creating a Package by Running a Wizard.
To add a connection manager to an existing package
In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.
In Solution Explorer, double-click the package to open it
In SSIS Designer, click the Control Flow tab, the Data Flow tab, or the Event Handler tab to make the Connection Managers area available.
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.
—or—
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.
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.
The Connection Managers area lists the added connection manager.
Optionally, right-click the connection manager, click Rename, and then modify the default name of the connection manager.
To save the updated package, click Save Selected Item on the File menu.
To delete a connection manager from a package
In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.
In Solution Explorer, double-click the package to open it.
In SSIS Designer, click the Control Flow tab, the Data Flow tab, or the Event Handler tab to make the Connection Managers area available.
Right-click the connection manager that you want to delete, and then click Delete.
If you delete a connection manager that a package element, such as an Execute SQL task or an OLE DB source, uses, you will experience the following results:
An error icon appears on the package element that used the deleted connection manager.
The package fails to validate.
The package cannot be run.
If you delete a connection manager that is based on a data source object, the data source object is not deleted.
To save the updated package, click Save Selected Items on the File menu.