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.
Explanation:
Tip: "32-bit operating system … 64-bit operating system" = "32 bit runtime"http://msdn.microsoft.com/en-us/library/ms141766.aspx
64-bit Considerations for Integration Services
Selecting 32-bit or 64-bit Package Execution in a SQL Server Agent Job
To run a package in 32-bit mode from a 64-bit version of SQL Server Agent, select Use 32 bit runtime on the Execution options tab of the New Job Step dialog box.