How to delete a DTS package (Enterprise Manager)

How to delete a DTS package (Enterprise Manager)

To delete a DTS package saved to SQL Server or Meta Data Services

1. In the SQL Server Enterprise Manager console tree, expand Data Transformation Services.
   
   
2. Do one of the following:
   • Click Local Packages for Data Transformation Services (DTS) packages saved to Microsoft® SQL Server™.
     
     
   • Click Meta Data Services Packages for packages saved to SQL Server 2000 Meta Data Services.
3. In the details pane, right-click a Data Transformation Services (DTS) package, and then click Delete.

   This deletes all versions of the package.

To delete a DTS package version saved to SQL Server

1. In SQL Server Enterprise Manager console tree, expand Local Packages.
   
   
2. In the detail pane, right-click the package, and then click Versions.
   
   
3. In the DTS Package Versions dialog box, click the package version, and then click Delete.

To delete a DTS package saved to a file

1. Using a file manager such as Microsoft Windows Explorer, click the folder containing your DTS packages.
   
   
2. Right-click the desired package file, and then click Delete.

See Also

Managing a DTS Package