SQL Server 2005 provides a utility called DTS Migration Wizard to help you move your legacy DTS 2000 packages to SSIS format. It is not guaranteed to work perfectly, but it will make a best-effort attempt.
Initially, you may want to install DTS runtime on the SQL Server 2005 box so you can continue running DTS 2000 package as is. To do that, you need to run setup again. This is how you do that:
1. Run setup.exe;
2. After installing supporting files, configuration check, and other preparation work, you are presented with “Components to Install” screen. Click Advanced button;
3. Expand Client Components, then pick Legacy Components;
4. Proceed to finish setup.
However, the Legacy Components are not supported on 64-bit platforms. You will get the message below if you try:
“None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install. To exit SQL Server Setup, click Cancel.”
Bummer. You can get more information here regarding Integration Services considerations on 64-bit computers.
2 responses to “DTS runtime and Legacy Components are not supported on 64-bit”
So what’s the answer, if you have 64 bit hardware and you want to use SQL Server 2005 and you don’t want too many problems with legacy SQL Server 2000 applications running DTS packages left right and center?
Do you have to install 32-bit win Server 2003 and then 32-bit SQL Server 2005 ?
In other words, when does MS plan to provide FULL support for x64 architecture?
I have no idea. I agree, I think it would have been very nice for Microsoft to support 64-bit DTS runtime, but I am not sure if it has plans to do that.
What you mentioned would work, namely, get a 32-bit box just for that purpose. Other ways you can consider are:
1. See if WOW (Windows on Windows) can help out on this. WOW is something that lets you run 32-bit app on a 64-bit machine;
2. You may consider installing a virtual machine. Cost wise, that is probably cheaper than a separate box, OS, and all that.