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.

  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.