You are a database administrator for AIOTestKing.com. You have a Data Transformation Services (DTS) package stored in SQL Server 2000 that you want to migrate into SQL Server 2005. The DTS package uses complex Microsoft Visual Basic Scripting Edition (VBScript) to dynamically configure precedence constraints. You run the SQL Server 2005 Package Migration Wizard, which fails to convert the package from SQL Server 2000 to SQL Server 2005. You need to ensure that the DTS package runs in SQL Server 2005. You must get the package running as quickly as possible. What should you do?

A.
Manually recreate the SQL Server 2000 Data Transformation Services (DTS) package as a SQL Server Integration Services (SSIS) package.

B.
Configure the SQL Server 2000 Data Transformation Services (DTS) task to not use precedence constraints. Then, run the SQL Server 2005 Package Migration Wizard again.

C.
Ensure that the SQL Server 2000 Data Transformation Services (DTS) package is wrapped in an Execute DTS 2000 Package task.

D.
Run the SQL Server 2005 Package Migration Wizard. If the upgrade is not successful, run a Transfer SQL Server Objects task.

Explanation:
The Execute DTS 2000 Package task runs packages that were developed by using the SQL Server 2000 tools. By using this task, you can include SQL Server 2000 DTS packages in SQL Server 2005 data transformation solutions.
A package can include both Execute Package tasks and Execute DTS 2000 Package tasks, because each type of task uses a different version of the run-time engine.