Thank you to our sponsors:


Upgrading DTS Packages to SSIS


Presenter: Brian Knight, Pragmatic Works


Session 13: September 16 at 12:00 GMT


Session Details

In this level-200 session, learn options for converting your Data Transformation Services packages to SQL Server Integration Services. The Microsoft “End of Life” policy for SQL Server 2000 has encouraged many organizations to seriously look at migrating their SQL Server 2000 servers to SQL Server 2005 or 2008. One of the biggest obstacles to a rapid migration is the DTS package issue.


To gain the performance benefits and a supported path forward for the functionality in DTS, these DTS packages should be converted into native SSIS. As we all know, the conversion is NOT straightforward. SSIS is more powerful and significantly different from DTS. Join us for this session and learn:

  • Why you should upgrade from DTS to SSIS
  • The advantages of SSIS over DTS
  • Options for converting DTS packages to native SSIS
  • How to add value to packages during the conversion process
  • How to assess the scope of a DTS conversion project (time, costs)

You’ll also see a demonstration of DTS xChange, a tool for converting DTS packages.


About the Speaker



Brian Knight—SQL Server MVP, MCITP, MCSE, and MCDBA—is the owner and founder of Pragmatic Works. He is also the co-founder of and Brian, a contributing columnist at several technical magazines, does regular webcasts at Jumpstart TV and is the author of a dozen SQL Server books. He runs the local SQL Server users group in Jacksonville, FL (JSSUG) and is a regular speaker at PASS Summit, SQL Connections, Microsoft Tech Ed, and Code Camps. You can read his blog at

Register now for 24 Hours of PASS!

Copyright 2013 by PASS | Terms of Use | Privacy | Login