You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a
Posted: Mon Oct 17, 2022 4:49 pm
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.
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.