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 |
|
ZachM
Starting Member
28 Posts |
 Posted - 2008-09-19 : 10:00:39
|
| Hi All, I need to migrate my dts from sql2k into ssis sql2k5. Is there a utility that I can execute in order to convert dts into ssis? Would I be able to convert 100% of the functionalities from dts into ssis?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-19 : 10:05:55
|
| You have a migration wizard available in sql 2005 management studio.You wont be able to convert 100% of functionalities of dts to ssis always. based on how complex your dts were the migration might range from 100 % successful to 0%. Worst case is when you will get only some script tasks and might need to rewrite the whole logic. |
 |
|
|
|
|
|
dts