CodeBetter.Com
CodeBetter.Com
RSS 2.0 via Feedburner
           Do you Twitter? Follow us @CodeBetter

Raymond Lewallen

Framework Design, Agile Coach, President Oklahoma City Developers Group, Microsoft MVP C#, TDD, Continuous Integration, Patterns and Practices, Domain Driven Design, Speaker, VB.Net, C# and Sql Server

DTS migration to SSIS

From Tom Rizzo’s blog, here is some news I knew I would have to go looking for sooner or later but I just haven’t had time to go research SSIS regarding what’s going to be involved in converting DTS packages.

Q) How do I move to SSIS?
A) It's a migration.  We have a migration wizard that will take your DTS packages and migrate them to SSIS.  The thing you have to remember is that SSIS is not a minor upgrade to DTS.  It's a re-write to make SSIS super scalable and have great performance and functionality.  The good thing is that we still ship the DTS 2000 runtime in certain versions of SQL Server 2005 so you can continue to run your DTS packages even as part of a SSIS workflow.



Leave a Comment

(required)  
(optional)
(required)  

Enter the numbers above:
Add

About Raymond Lewallen

Working primarily in the public sector during his career, Raymond has designed and built several high profile enterprise level applications for all levels of the government. Raymond now works as a solutions architect for EMC. Raymond is an agile coach, Microsoft MVP C# and also president of the Oklahoma City Developers Group and Oklahoma Agile Developers Group. Raymond spends a lot of his time learning and teaching such things as Test Driven Development, Domain Driven Design, Design Patterns and Extreme Programming practices and principles, to name a few. Raymond is also an advocate of Alt.Net. Raymond is primarily a framework guy, so don't ask him anything about UI :) Check out Devlicio.us!