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.
You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!