You design a Business Intelligence (BI) solution by using SQL Server 2008. You develop a SQL Server 2008 Integration Services (SSIS) package to perform an extract, transform, and load (ETL) process from a Microsoft Access database to a SQL Server 2008 data warehouse. The package is developed on a computer that runs a 32-bit operating system. You deploy the package to a server that runs a 64-bit operating system. You create a SQL Server Agent job to run the package. The package fails to run when the job starts. You need to ensure that the package runs successfully.
What should you do?
A.
Redeploy the package to the Program Files (x86) folder.
B.
Enable the Use 32 bit runtime option in the job step of the SQL Server Agent job.
C.
Rebuild the package on a computer that runs a 64-bit operating system. Redeploy the package to the server.
D.
Modify the project of the package by setting the Run64BitRuntime property to TRUE . Rebuild and redeploy the package to the server.