DTS to SSIS 2008 Migration
Posted by decipherinfosys on March 3, 2009
In case you have not migrated from SQL Server 2000 to SQL Server 2005 and have waited for SQL Server 2008, then chances are that you would be looking for a way to do the migration of your DTS packages to SSIS 2008 as well. In one of the current projects, we have the same requirement. DTS packages can still be run in SQL Server 2008 i.e. the support for DTS packages still exists in SQL Server 2008 but we strongly recommend moving to SSIS because of the rich features of SSIS. Some of the client shops have still chosen to run the DTS packages because of the cost and time involved in moving the DTS pacakges over to SSIS and subsequent testing effort. Some of that time can be reduced by making use of tools like dts xchange (from Pragmatic Works) – we have given the link below.
Here is a compilation of resources that we used for helping in our work…dts xchange does a better job than the DTS Migration Wizard from Microsoft. The article on their site also lists out the differences between dts xchange and the DTS Migration Wizard.
- DTS vs SSIS Basics – our post here.
- Scalablity Experts blog posts on this topic – Part 1 and Part 2.
- DTS xChange – here.
- Microsoft MVP Brian Knight’s article on MSDN – here.
- Mark Kromer’s post on the new features in SSIS 2008 – here.
- Arshad Ali’s post on SSIS on sql-server-performance.com – here.
- And of course, the bible of SQL Server – BOL.