What should you do?

Correct Answer for the following Question is given below

You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Windows Azure SQL Database database. The package has been deployed to a production server that runs Windows Server 2008 R2 and SQL Server 2012.The package fails when executed on the production server.You need to ensure that the package can load the Excel workbook data without errors. You need to use the least amount of administrative effort to achieve this goal.What should you do?XLSX files, the new file type in Excel 2007/2010 cannot be opened with Excel Source/Destination in SSIS. To use XLSX in SSIS we need to install ACE driver and use OLE DB Source/Destination to read read/write data in XLSX files. ACE is a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access (*.mdb and *.accdb) files and Microsoft Office Excel 7 (*.xls, *.xlsx, and *.xlsb) files toMicrosoft SQL Server. If the SQL Server or your development box does not have ACE driver then install that 1st.Note:* The most efficient way to link to SQL Server is using an OLEDB connection manager.Incorrect:Not B:* Address Windowing Extensions (AWE) is a Microsoft Windows application programming interface that allows a 32-bit software application to access more physical memory than it has virtual address space.* Address Windowing Extensions (AWE) is a set of extensions that allows an application to quickly manipulate physical memory greater than 4GB.Certain data-intensive applications, such as database management systems and scientific and engineering software, need access to very large caches of data. In the case of very large data sets, restricting the cache to fit within an application’s 2GB of user address space is a severe restriction.


What should you do?


Install a 64-bit ACE driver and execute the package by using the 64-bit run-time option.

Enable Address Windowing Extensions (AWE) for the local SQL Server instance.

Replace the SSIS Excel source with a SSIS Flat File source.

Install a 64-bit ACE driver and replace the Excel source with an OLE DB source.

Correct Answer

The Correct Answer for this Question is

Install a 64-bit ACE driver and replace the Excel source with an OLE DB source.


The Question – What should you do? has been answered correctly and answers for the question is Install a 64-bit ACE driver and replace the Excel source with an OLE DB source.

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

Leave a Comment