You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Microsoft Azure SQL Database database. The package has been deployed to a 64-bit production SQL Server. The package fails when executed on the production server. You need to ensure that the package can load the 32-bit Excel workbook data without errors. What should you do?

A. Install a 64-bit ACE driver and replace the Excel source with an OLE DB source.
B. Install a 32-bit instance of SSIS side-by-side with the 64-bit version.
C. Replace the SSIS Excel source with a SQL Server source.
D. Create a custom SSIS source component that encapsulates the 32-bit driver and compile it in 64-bit mode.

  Discussion forum


Leave an answer