Export (0) Print
Expand All
Expand Minimize

How to delete a DTS package (Enterprise Manager)

SQL Server 2000

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

Show:
© 2014 Microsoft