You are a database administrator for AIOTestKing.com. You migrate several SQL Server 2000 Data Transformation Services (DTS) packages to a 64-bit version of SQL Server 2005 Standard Edition. After migrating the packages, you notice that they do not run.
You verify that the packages run on a 32-bit version of SQL Server 2005 Standard Edition. You need to ensure that the packages run. You must minimize the amount of additional development time required. What should you do?
A.
Run the packages by using the Dtsrun.exe command-line utility.
B.
Rewrite the packages by using the 64-bit version of SQL Server 2005 Standard Edition Server Integration Services (SSIS).
C.
Run the packages in the SQL Server 2000 DTS runtime.
D.
Configure the packages to run in 32-bit mode.
Explanation:
a DTS package created on a 32-bit architecture will not automatically run in an 64-bit architecture. You have to “emulate” a 32-bit architecture for the DTS package to run in.