What are the tools available for DTS to SSIS package conversion as part of the SQL servr upgrade and which ones do you recommend?.
A:
I wouldn't trust any such tool, if any exist. These conversion tool are typically only any use as a learning aid.
Rewrite the packages in SSIS as and when you get a chance.
EDIT: Downvotes!!?!?? Jeez! So are you guys all out there running apps which have been converted from VB to .net against databases converted using the oracle to sql conversion tool? I'll bet you're not.
Chris Needham
2009-08-12 10:58:23
Saying you wouldn't trust a utility and not even knowing about existing tools seems overly pessimistic. Of course, none of us would expect DTS go 'poof' into SSIS, but you should give the technology a chance!
Sam
2009-08-12 21:48:20
@Sam - I know enough about DTS and SSIS and the differences between them to know that no tool is going to give a decent conversion. At the core of SSIS is the data pipeline, whereas DTS just runs a series of tasks. You say yourself no tool is going to do it, but then criticise me for saying the same.
Chris Needham
2009-08-13 09:26:47
A:
If you have a large amount of packages, you might try the migration wizard from microsoft. It will not migrate everything.
It will give you a nice start.
Of course you will test the converted packages thoroughly.
From http://technet.microsoft.com/en-us/library/cc966519.aspx
Integration Services
Upgrade Tool: None
Migration Tool: DTS Migration Wizard
Migration Method: Migration Wizard converts 50-70 percent of tasks, requires some manual migration; runtime DTS DLLs available in SSIS; package re-architecture is recommended
Some screen shots of the process.
http://wiki.sqlis.com/default.aspx/SQLISWiki/MigrationWizardSteps.html
Sam
2009-08-12 21:44:42
thanksyes there are large amount of packagesAre there any other tools than migration wizard
kishore
2009-08-13 16:59:56
A:
SSIS is so much better than DTS (especially the 2008 version) that you might do better to rewrite the packages.
John Saunders
2009-08-12 21:48:43
No, he's asking for a conversion. I mean redesign to take advantage of new features. DTS didn't have data flow did it? Or real loops?
John Saunders
2009-08-12 22:33:55
+1
A:
Rewriting the packages isn't an option for larger scale companies where they have thousands of packages. I was dealing with a customer the other day that received a quote for more than $500k to convert their packages and 2 years and a staff of 8. No one can wait that long to proceed with their migration project. The DTS xChange tool by Pragmatic Works will automate 90% of the migration for you. The tool has migrated more than 200K packages at this point and comes with an additional tool to help with ActiveX Script Tasks.
A:
You can try DTS xChange from Pragmatic Works its the only 3rd party solution for DTS to SSIS conversion project. They have some amazing BI tools specially for DTS and SSIS. If you are new to SSIS then DTS xChange will do far better job than rewriting or using MS Wizard. They also have project planning tool included with DTS xChange which will detect your migration project cost and time.
http://www.pragmaticworks.com/Products/Business-Intelligence/DTSxChange/
and here compare with MS Wizard
www.pragmaticworks.com/products/business-intelligence/dtsxchange/DTSxChange-vs-MSWizard.htm