🎴 Flashcard Mode
technology Online Quiz - 1841
Card1 / 20
Mastered0
Review0
QuestionClick to flip
What is the connection manager you should use to import an Excel 2007 file into SQL Server using SSIS?
AnswerClick to flip back
A
Microsoft Office 12.0 Access Database Engine OLE DB Provider with Extended property set to Excel 12.0
💡 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.