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 |
|
majnoon
Starting Member
26 Posts |
 Posted - 2003-01-10 : 09:32:07
|
| Is it possible to copy a DTS package from one SQL server to anotherWishing you a peaceful journey |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-01-10 : 09:36:30
|
| Yes.Read the chapter "Saving a DTS Package" in books online.Jay White{0} |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-10 : 09:36:53
|
| Yes, register the other server in Enterprise Manager. Open the DTS package in design mode, choose Save As... (NOT Save) and then use the other SQL Server as the place to store it. |
|
|
|
majnoon
Starting Member
26 Posts |
Posted - 2003-01-10 : 10:18:12
|
| Thanks for that.Wishing you a peaceful journey |
|
|
|
|
|
|
Copy DTS Package