Deleting a DTS Package

Data Transformation Services

Data Transformation Services

Deleting a DTS Package

You can delete any Data Transformation Services (DTS) package. The method you use depends on the format in which you saved the package. For example:

  • If the package was saved to Microsoft® SQL Server™ or SQL Server 2000 Meta Data Services, delete the package through SQL Server Enterprise Manager.

  • You can only delete a package saved to SQL Server or Meta Data Services if you are the package creator or a member of the sysadmin fixed server role. If the package was saved to a structured storage file or to a Microsoft Visual Basic® file, delete the package through a file manager.
Deleting Package Versions

To delete package versions, you need to consider the format in which you saved the package. For example:

  • If you save a package to SQL Server, you can delete any package version.

  • If you save a package to Meta Data Services, you can delete only the most recent package version.

  • If you save a package to a structured storage file, you must delete the entire file. You cannot delete individual packages or package versions saved to the file.

Packages saved to a Visual Basic file do not contain version information.

To delete a DTS package