Multiple choice technology

What is the connection manager you should use to import an Excel 2007 file into SQL Server using SSIS?

  1. Excel Connection Manager with Excel version 2007

  2. Microsoft Jet 2007 OLE DB Provider

  3. Microsoft Office 12.0 Access Database Engine OLE DB Provider with Extended property set to Excel 12.0

  4. File Connection Manager
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To import Excel 2007 (.xlsx) files in SSIS, you must use the Microsoft Office 12.0 Access Database Engine OLE DB Provider with the Extended Properties set to 'Excel 12.0' because the older Jet provider only supports up to Excel 2003.

Keep practicing — related questions