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.
| Author |
Topic |
|
vusil
Starting Member
22 Posts |
 Posted - 2004-06-30 : 10:18:53
|
| Hi guys,How do I move/copy a dts package from 1 sql server to another?I'm using sql 2k enterprise. Or alternatively move a job? If I move a job will the dts packages called by the job move over automatically?Thanks for your time. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-06-30 : 11:48:34
|
| You can move a DTS package a couple of ways. The easiest would be to double-click it to open it up in designer and then save it to another SQL Server. As long as you have rights on the other box, you'll be able to save it in the new location.You could also use a tool that the guys over at www.sqldts.com created called DTS Backup 2000. This allows you to select multiple DTS packages from a source system and move them all in one shot to the destination host.Keep in mind that either one of these methods only saves the current version of the package. The history, or past versions, of each package does not get copied over.You will have to re-create your SQLagent job as well. Moving just the job will not move the DTS.-ec |
 |
|
|
vusil
Starting Member
22 Posts |
Posted - 2004-07-01 : 08:10:16
|
| Thanks eyechart.While we talking about dts I read somewhere on sqlteam that you can also use the sysdtpackages system tables.I don't seem to have any object by that name on my server; either under user databases or the system databases. What could possibly be the explanation?Thanks. |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-07-01 : 08:24:45
|
| sysdtspackages should be in msdb. If you've used meta data services, this will also be in msdb.Steve no function beer well without |
|
|
|
|
|
|
dts packages