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 |
|
NguyenL71
Posting Yak Master
228 Posts |
 Posted - 2009-03-02 : 12:11:20
|
| Hi,I need to script-out about 400 ssis packages (SQL 2005) from an old server migrate them into anew server. Does anyone knows where I can find scripts/tools that would help me to make thismigration successfully?. I hope there is a better way than manually export one by one.Thank you so much in advance.Ex: Old_Server msdb->DeveloperPkg --------> New_Server msdb All_Packages (All packages will go to All_Packages folder). DeveloperPkg. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-04 : 11:25:29
|
| Use Package Migration Wizard to do this.But you might have to rewrite DTS package involving Activex script if from 2000 to 2005. |
 |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-03-04 : 18:24:02
|
| There is a tool called DTSxchange, it does DTS-to-SSIS migration job pretty well. I dont know if they have any evaluation version which allows migration of 400 packages. Still no harm in trying. |
|
|
|
|
|
|
Script/Tools to Script-out 400 ssis packages.