Share via


How to: Delete a Connection Manager in a Package

This procedure describes how to delete a connection manager from a specific package. Deleting the connection manager that is based on a data source object does not delete the data source object.

If you delete a connection manager used by a package element such as an Execute SQL task or OLE DB source, the error icon appears on the element, the package fails to validate, and the package cannot be run.

To delete a connection manager

  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 that you want to delete, and then click Delete.

  5. To save the updated package, click Save Selected Items on the File menu.

See Also

Tasks

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

Concepts

Data Source (SSIS)
Connection Managers
Connection Manager How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance