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-07-03 : 07:43:16
|
| Vicky writes "We are upgrading to 2000 server by copying databases from 7.0 server on one host to 2000 server on another host. Databases can be copied, jobs can be scripted, and there is a thread about transferring logins and passwords. The only thing in question is local DTS packages. My questions is:How are local DTS packages copied over to the new 200 server? I can open them one by one, and save them as file, and reopen in 2000 server. Is there any faster way or batch copy?Thanks,Vicky" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-07-03 : 17:30:54
|
| See this FAQ on transferring DTS packages[url]http://www.sqldts.com/default.aspx?6,105,204,0,1[/url]HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
 |
|
|
|
|
|
Upgrade DTS packages from SQL Server 7.0 to SQL Server 2000