SQL Server 2000 to SQL Server 2008 DTS Package Conversion Runtime Issue
By: Greg Robidoux | Updated: 2010-11-15 | Comments (5) | Related: More > Integration Services Upgrade
When converting DTS packages from SQL Server 2000 to SQL Server 2008 you may encounter this error message: "The Package Migration Wizard requires the SQL Server 2000 Data Transformation Services (DTS) runtime. To install the DTS runtime, run the SQL Server Installation Wizard. On the Components to Install page, click Advanced, then select Legacy Components for installation." The first thought is to run the SQL Server setup process, but after you go through the initial setup screens you find out that there is no Advanced page, so how do you do this?
When converting DTS packages from SQL Server 2000 to SQL Server 2008, you might get this error message when you try to use the "Migrate DTS 2000 Package" option within BIDS.
As I mentioned above, if you run through the SQL Server setup process, you won't find what you are looking for. So how do you get past this error?
What you need to do is download the "Run-time Support for DTS Packages" from the Microsoft site. This can be found on this page: Microsoft SQL Server 2008 Feature Pack page. You then need to scroll down until you find the "Microsoft SQL Server 2005 Backward Compatibility Components". Yes even though it says SQL Server 2005, this does work for SQL Server 2008 and SQL Server 2008 R2. Once there you need to select the correct package either for X86 (32 bit), X64 (64 bit) or IA64 (Itanium 64 bit).
After you download the MSI you will need to run the install. Just double click on the MSI file and go through the screens. If you only want to convert DTS packages to SSIS packages you only need to select the first option as shown below. If you want to do additional tasks, you can install the other components as needed.
Once this has been installed you will be able to use the "Migrate DTS 2000 Package" feature within BIDS.
- Read these related tips:
- Check out this video: Learn how to migrate your DTS packages to SSIS
Last Updated: 2010-11-15
About the author
View all my tips