Home Library Learn Samples Downloads Support Community Forums
This topic has not yet been rated - Rate this topic

Delete Packages

SQL Server 2012

In SQL Server Data Tools (SSDT), you can delete packages listed as saved to the file system. If you delete a package, it is deleted permanently and it cannot be restored to an Integration Services project.

For information about deleting packages stored in other locations, see dtutil Utility.

Note Note

If you want to remove packages from an Integration Services project, but use them in other projects, then you should use the Exclude From Project option instead of the Delete option.

In the Delete Object dialog box, confirm the deletion by selecting OK.

Transact-SQL access

To delete a package that is stored on the server, call the stored procedure, catalog.delete_package (Integration Services Database).

Programmatic access through the managed API

See the Microsoft.SqlServer.IntegrationServices.Store namespace and its classes, especially the Microsoft.SqlServer.IntegrationServices.Store.PackageInfo class and its Microsoft.SqlServer.IntegrationServices.Store.PackageInfo.Drop method.

To delete a package in Business Intelligence

  1. In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want to delete.

  2. In Solution Explorer, right-click the package, and then click Delete.

  3. Click OK to confirm the deletion or click Cancel to keep the package.

To delete a package that is stored on the Integration Services Server

  1. In SQL Server Management Studio, connect to the Integration Services server. That is, connect to the instance of the SQL Server Database Engine that hosts the Integration Services database.

  2. In Object Explorer, expand the tree to display the Integration Services node.

  3. Expand the Integration Services node to display the Packages and Configurations nodes.

  4. Expand the Packages node to display the list of packages stored on the server.

  5. Right-click the package that you want to delete, and select Delete to open the Delete Object dialog box.

  6. In the Delete Object dialog box, confirm the deletion by selecting OK.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.