You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
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

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply