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 |
|
chander_2580
Yak Posting Veteran
76 Posts |
 Posted - 2008-04-04 : 01:53:29
|
| Gurus!!I have to transfer existing DTS packages from sqlserver 2000 to sqlserver 2005, Please let me know the steps by which i can migrate all the runing DTS into SSIS into sqlserver 2005Thanks Chander |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-04 : 11:57:42
|
| You have a migration wizard available in SQL business studion. Start the wizard and follow the steps. Refer this article for more details:-http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1216481,00.html |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-05 : 12:45:16
|
| You can also migrate by SQL server 2005 interface for SQL server 2000Goto Legacy-DTS- migrate |
|
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2008-04-07 : 01:44:30
|
| DO remember to update all the recent drivers if the DTS consists task of connecting to some other databases other then SQL server database like Informix etc.. |
|
|
|
chander_2580
Yak Posting Veteran
76 Posts |
Posted - 2008-04-08 : 18:19:30
|
| Hi Thanks so much for all of you for your valueable comments ..its working fine ... gr8 ...thanks alot once againregardschander |
|
|
|
|
|
|
Migration of DTS from 2000 to 2005