Post reply

Moving DTS Packges

  • February 3, 2003 at 1:53 pm

    #105619

    I have a system that has a number of DTS Packages stored locally, how can I move them from Dev to Prod -> AND <- retain formating, annotations etc.

    I've tried the DTSBackup utility, and even my own VB program using DTS / Package ... constructs.

    I expect to be moving them regularly, and more so with other systems ??

    I can move them individually, for now OK there are 8, but I could see hundreds.

    KlK, MCSE


    KlK

  • February 3, 2003 at 2:18 pm

    #447892

    Try DTSBackup 2000 at sqldts.com

    http://www.sqldts.com/default.aspx?220,272,272,1,1

    If you're moving the packages between SQL Servers, make sure you have 'Direct Transfer' select in the options. This will preserve the formatting and annotations.

    Really though, you shouldn't worry about the formatting and annotations. We've got over 100 packages here and it's too much work to try and maintain the formatting, etc...

    Maybe Microsoft will make these things more persistent in the next release.

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

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

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