Post reply

How to delete DTS Package revisions

  • June 1, 2007 at 4:39 am

    #70180

    Hello All,

    Do anybody know how to delete the revisions of dts package.

    Whenever i do changes to the dts package and save it will create a new revision, thus it is doubling the size of the dts package file (*.dts). I like to delete the old versions.

    Help on this is appreciated

    Thanks in advance.

    Thanks,

    Raghavendra

  • June 1, 2007 at 9:11 am

    #710363

    It's easy if the packages are stored in SQL Server.  Right-click on the package listed under Local Packages, select Versions..., choose the versions you want to delete and click the delete button.

    If it's stored as a file, I suspect you'll have to open it in DTS Designer, save it locally, delete the old versions, then resave it as a file.

    Greg

    Greg

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply