Results 1 to 6 of 6

Thread: Delete DTS Package Version

  1. #1
    Join Date
    Dec 2009
    Posts
    79

    Delete DTS Package Version

    How would I delete a particular version with a DTS Package.

    (SQL Server 2000)

    There has to be a way to do it, but I've searched high and low and come up empty.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Right click the package in enterprise manager and go to versions, you can pick specific version and delete it.

  3. #3
    Join Date
    Dec 2009
    Posts
    79
    My fault...I should have said that these packages are stored locally, not on the server itself.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Then just delete the file.

  5. #5
    Join Date
    Dec 2009
    Posts
    79
    Quote Originally Posted by rmiao View Post
    Then just delete the file.
    If I do that I'll delete my DTS package which would mean I would have to recreate it again from scratch.

    I have 20 of them.

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Open package from file in EM then find if has versions option.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •