Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Local DTS Package

Author  Topic 

dewacorp.alliances

452 Posts

Posted - 2007-01-17 : 18:56:18
Hi there

Does anyone point me to the right directin on how to move package from 1 server to another?

BTW ... where this information is kept? Which database? Is it msdb? or master?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-01-17 : 18:57:43
Just do a Save As on the package. You can then save it to another SQL Server.

DTS packages are stored in the msdb.dbo.sysdtspackages system table.

Tara Kizer
Go to Top of Page
   

- Advertisement -