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 |
|
rolandsantos
Starting Member
24 Posts |
 Posted - 2008-02-07 : 01:13:07
|
| I have lots of DTS packages and jobs in SQL 2K, we are planning to migrate to SQL 2005. Will my DTS and jobs still work? If not, what are the procedures for migration. thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-07 : 01:20:57
|
| Its always a pain to migrate DTS to SSIS packages as their underlying architectures are completely different. Even after migration you might need to rewrite most of tasks in packages as migration wizard will convert most tasks to activex scripts which it cant convert while migrating. So if there's a possible way, go for rewriting the package in SSIS rather than migrating it. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-07 : 21:27:11
|
| We migrated several sql2k to sql2k5, all packages and jobs work fine. |
|
|
|
Qualis
Posting Yak Master
145 Posts |
Posted - 2008-02-08 : 09:07:22
|
| It all depends on what the packages do. Some will move over just fine. If the packages utilize ActiveX scripting heavily you will most likely have to convert the concepts into VB.Net code or equivalent built in tasks. |
|
|
|
|
|
|
migrating SQL 2K DTS to SSIS