Post reply

DTS Local packages Backing up and restore

  • September 20, 2004 at 7:30 am

    #102210

    We have loads of local packages that rebuild some databases. We regulary backup the databases only. How do I backup/restore the packages in one go or do I have to do them manually and individually.

    I read somewhere that the MSDB contain all the DTS packages and by restoring the MSBD backup this should do the trick. Any help appreciated

  • September 20, 2004 at 5:20 pm

    #523726

    Local packages are stored in the sysdtspackages table in msdb.  You can restore packages by restoring msdb.

    Greg

    Greg

  • September 21, 2004 at 2:25 am

    #523753

    Thanks Greg, I look forward to testing it today.

    Regards, Ramesh

  • September 21, 2004 at 7:32 am

    #523805

    Ramesh,

    There is also a handy little tool available from http://www.sqldts.com called DTSBackup 2000, and the price is just right

  • September 21, 2004 at 2:42 pm

    #523881

    I had to come up with a way to back them up rather than saving to an external file, and then to load them into VSS.

    It was a little clunky, but seemed to server the purpose.  And, if nothing else, it was a pretty good learning experience.  Basically, I just did a raw binary dump of the syspackages into an XML file.  Restoring was a little complex.  If any of objects (ie, connections, tables, etc) didn't exist when restoring the package, opening it was somewhat painful.  Nonetheless, I was able to do it.  Got it to work with a small VB app.  I don't recall, but possibly a VBS file as well.

    If it's at all of interest to anyone, let me know and I will dig it out of the archives.

     

Viewing 5 posts - 1 through 4 (of 4 total)

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