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

technology

  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

Show answer
Correct Option: C

Find more quizzes: