Archiving DTS Packages

  • I know how to transfer DTS packages, but how would I archive them before deleting ones I no longer need?  Is there a way?

    Thanks!

  • Plenty, but not all of the ways are easy if you want to get them back.

    Best way if you want to get them back quickly is to copy them onto another sql server database. E.g an old test box.

    Or save them as structure storage files. You can right click data transformation service in EM and select load package.

    If you are not likely to want to get them back, then save them as visual basic file. You can load these back into sql server by commenting out a couple of lines and the running the code in vba on something like word.


    ------------------------------
    The Users are always right - when I'm not wrong!

  • Excellent!  Thanks for taking the time to write out different options.  Much appreciated

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

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