technology Online Quiz - 1841

Time: 00:00:00

Attempted

Not Attempted

Marked For Review

Attempted & Reviewed

Question 1 of 20

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

Select Your Answer:

Excel Connection Manager with Excel version 2007

Microsoft Jet 2007 OLE DB Provider

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

File Connection Manager

Mark for Review

Attempted

Not Attempted

Marked for Review

Attempted & Reviewed

Current