Hello all,

I need to recover a DTS package from a backup tape of a SQL 7 server that is
no longer active. We need to get it into a SQL 2000 database.

While exploring our current system I see several sysdts... tables in the
msdb database that seem to contain DTS info. Is there a way to copy the msdb
database from the backup as a new name and reconstruct the DTS package from
info in the sys tables? Or any other way to do this?
--
Thanks for any advice, Rosko.

Yep.

If you stored your packages in msdb then

Restore msdb as a different database name and then pump sysdtspackages
to your new msdb.

Allan

"Rosko" <Rosko (AT) discussions (DOT) microsoft.com> wrote

Hi Allan

Further to that, does each row in sysdtspackages contain all of the required
data to restore a dts? Considering that I had say 10 versions of 1 dts
stored in that table, could I just restore the most current version from the
backed up MSDB into the MSDB database, and have a fully functional DTS
(assuming all connections/file structure info was OK)

thx, Ben



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Yep

Each line is only a version

Allan

"Ben Rum" <bundyrum75 (AT) xx (DOT) yahoo.com> wrote