dbTalk Databases Forums  

Restore DTS from old Harddisk without running Server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Restore DTS from old Harddisk without running Server in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dirk Verweyen
 
Posts: n/a

Default Restore DTS from old Harddisk without running Server - 10-08-2003 , 09:39 AM






Hi!

I have setting up a new SQL-Server and need from the old one
some DTS-Packages. The only what i have from the old server is
the harddisk, no more running hardware. Have i a change to get
the DTS-Packages any way over the files?

Greetings , Dirk



Reply With Quote
  #2  
Old   
dba
 
Posts: n/a

Default Re: Restore DTS from old Harddisk without running Server - 10-08-2003 , 12:11 PM






The DTS packages are in th table SYSDTSPACKAGES in database MSDF.
So you can install a new server ,bring the .mdf and .ldf from the harddisk
and try to attach them.

Zvi
"Dirk Verweyen" <verweyen (AT) kemper-media (DOT) net> wrote

Quote:
Hi!

I have setting up a new SQL-Server and need from the old one
some DTS-Packages. The only what i have from the old server is
the harddisk, no more running hardware. Have i a change to get
the DTS-Packages any way over the files?

Greetings , Dirk





Reply With Quote
  #3  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Restore DTS from old Harddisk without running Server - 10-08-2003 , 01:28 PM



You could look at this article

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

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Dirk Verweyen" <verweyen (AT) kemper-media (DOT) net> wrote

Quote:
Hi!

I have setting up a new SQL-Server and need from the old one
some DTS-Packages. The only what i have from the old server is
the harddisk, no more running hardware. Have i a change to get
the DTS-Packages any way over the files?

Greetings , Dirk





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.