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
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.
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)