Systems Engineering and RDBMS

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 – here.
  • And of course, the bible of SQL Server – BOL.

One Response to “DTS to SSIS 2008 Migration”

  1. […] We had also compiled the resources for the DTS to SSIS migration – you can access them here.  It also has links to other very useful material available on the net. Possibly related posts: […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: