DTS and Migration Wizard

Question

DTS and Migration Wizard

bshaw

Right there with Babe

Points: 750
More actions
September 29, 2014 at 1:09 pm

#297043

Beyond 2008 R2, there is no backward compatibility when it comes to working with my DTS packages that I will be moving from 2000 to 2008. My question is, when I use the Migration Wizard to move the packages (to msdb database), are they then SSIS packages, or do they remain DTS packages that will not work when we jump to 2012. I'm trying to determine if I need to re-create all DTS packages in SSIS, or will the migrated packages work in 2012?
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 1

I would not try to migrate/upgrade DTS packages.

SSIS offers new ways to do things, so I would rebuild each package from scratch. With each package, I would look for the best way achieve the desired results in SSIS and create a new package that does this.

I know it's more work, but depending on what the packages do, this way has lots of potential for performance improvements.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

ZZartin SSC-Dedicated Points: 30921 More actions · Answer 2

Alvin Ramard (9/29/2014)
I would not try to migrate/upgrade DTS packages.
SSIS offers new ways to do things, so I would rebuild each package from scratch. With each package, I would look for the best way achieve the desired results in SSIS and create a new package that does this.
I know it's more work, but depending on what the packages do, this way has lots of potential for performance improvements.

Indeed rebuilding from scratch is probably the best way to go, I never had good luck with the migration wizard. Don't expect it to be as easy as just running the wizard and everything working perfectly, even relatively simple DTS packages will produce unusable SSIS package through the migration wizard.

bshaw Right there with Babe Points: 750 More actions · Answer 3

I have had mixed success migrating the packages. I guess I'm just trying to confirm that even with a successfully migrated package, it will not execute after 2008?