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-11-27 : 08:17:11
|
| Aris writes "I have an SQL Server standard edition, SP4 that I am going to be moving onto a SQL Server 2000 Enterprise Edition SP3 soon enough, and I am onto the testing process to ease up onto the process (compatibility issues etc). However I am having the (probably asked often enough) question to ask you : Being that I cannot restore the MSDB database over the Windows 2000 database, hense I cannot massively have my DTS's onto the 2K machine, (there are close to 60DTS),is there any other way,rather than just manually saving them over that server ?Thank you in advance for your helpAris Routis" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-11-27 : 09:11:59
|
| I always oprefer to run dts packages from files the there's no problem with releasing packages and copying them to other servers.In msdb the packages are stored in sysdtspackages and you can just copy the rows from one server to another.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Other way rather than moving manually DTS packages