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 |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2008-03-19 : 22:00:54
|
I need to move total of 50 DTS packages from SQL 2000 to SQL 2005.Could someone give me the best way to do this ?Do I need to just save the package onto the new server OR do I use the DTS package migration wizard.What are the problems that can arise ?  |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 00:33:26
|
| Use DTS package migration wizard, it can migrate all packages in one shot. |
 |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-03-27 : 11:48:36
|
Point Noted rmiao A few more Questions:-Have you tried using Execute DTS 2000 Package Task?Can that also be used for the migration ? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-27 : 22:50:54
|
| You mean use Execute DTS 2000 Package Task to migrate packages? Don't think they are same. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-27 : 23:01:27
|
| In legacy for SQL 2005You can also migrate with migrate option(all packages). |
|
|
|
|
|
|
Methods to move existing DTS packages