sql server dts: to get dts from the msdb database -- sql server dts

Re: to get dts from the msdb database

Allan Mitchell
3/7/2007 12:00:00 AM

sql server dts: Restore the msdb db to a db of another name and then simply extract the
table from there.

Transferring DTS Packages
(http://www.sqldts.com/204.aspx)

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

to get dts from the msdb database

anandsatchin NO[at]SPAM gmail.com
3/7/2007 6:08:52 AM

Hi...

I hope if any one could shed light on my problem

we had a hardware crash on our Database server (sql server 2000) and
then Installed a fresh sql server 2000 installation and restored my
database.

But when I tried to restore the msdb file..it is not allowing me to
restore the files and throwing sql login errors ( I am assuming this
could be due to the msdb file is from the crashed sql server 2000 and
it is not matching with the setting of the new sql server )

The main problem.. is i need to get back all of my dts packages from
the sysdtspackages table in the msdb database

cheers
Anand

Re: to get dts from the msdb database

anandsatchin NO[at]SPAM gmail.com
3/7/2007 8:18:25 AM

Hi,

I did try to create a new database eg. testmsdb and add the msdn db to
it.. but when I reconnected the server..it says suspect.. I havent got
any clue.....

Creating a new database

database name - testmsdb

data files - C:\Program Files\Microsoft SQL Server\MSSQL\data
\testmsdb.MDF

transaction log - C:\Program Files\Microsoft SQL Server\MSSQL\data
\testmsdb.MDF

Re: to get dts from the msdb database

Query Builder
3/9/2007 2:09:08 PM

Well, the database is in suspect mode and you may want to bring it out
of suspect mode. There are threads to help you do that. But if you
have a good backup then you should just restore it from the good
backup the msdb db onto some new name.. then pump the data out of
SYSDTSPackages tables from the link provided above..

Good luck..

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.