SSIS uses the JET provider under the covers to access earlier versions of Excel and Access. That is what happens when you use the Excel connection manager, which is a wrapper around JET provider. By the same token, connectivity to Access is also currently wrapped around JET, and offered by a special user interface in SSIS.

If you are dealing with Office 2007, you must use the new ACE provider, please see the page on Office 2007. There's also a step by step instruction on how to use Excel.

Microsoft Excel Connectors

 

By

Name

Data Access API

Supported Excel Versions

64 bit

Metadata support

Provider Notes

FAQ

Microsoft

Excel Source

Excel ISAM Driver

ALL

Interactive Edge

DataDefractor

Direct BIFF Read

ALL

yes

Worksheets, PivotTables

 

See website


Note: This article has been ported over from http://ssis.wik.is/ Note: If you were the owner of above article, please update it to the latest or with other appropriate information.