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…

Question

Options

• AInstall a 64-bit ACE driver and execute the package by using the 64-bit run-time option.
• BEnable Address Windowing Extensions (AWE) for the local SQL Server instance.
• CReplace the SSIS Excel source with a SSIS Flat File source.
• DInstall a 64-bit ACE driver and replace the Excel source with an OLE DB source.

• A
  10% (2)
• B
  5% (1)
• C
  10% (2)
• D
  75% (15)

Explanation

XLSX files, the new file type in Excel 2007/2010 can't be open 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 to Microsoft SQL Server. If the SQL Server or your development box does not have ACE driver then install that 1st. - The most efficient way to link to SQL Server is using an OLEDB connection manager. - 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.

No community discussion yet for this question.