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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-28 : 07:29:38
|
| Kevin writes "I currently have a SQL7.0 server running on NT4.0. I have recently installed a new sql 2000 sp3 server on Windows 2003 Enterprise Ed using clustering. My question is how do I get the DTS packages copied over to the new SQL server. When I do an export it only does the databases. The only way I can think to do it is to save the DTS's as a file on the new server and open it up and save in meta repository. THis seems like an awful lot of work and there hast to be an easier way." |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-08-28 : 07:33:02
|
Your other twothree options are a.) open each dts package and "save as" to the new server or b.) write a custom DMO app to do the same or c.) restore a backup of your MSDB database from one to the other.Jay White{0} |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-28 : 12:30:32
|
| You could also just export the data from msdb.dbo.sysdtspackages. This is the system table where the DTS packages are stored. Hopefully, the table layout did not change between the two versions.Tara |
|
|
|
|
|
|
DTS Packages