Sep
1
2010

Making SSIS work with the 64-bit Excel (ACE) provider

I've previously blogged about the challenges of the new 64-bit ACE Provider that includes the Excel driver, since the 32-bit and 64-bit versions cannot be installed side-by-side.

In this detailed post that includes screen shots, Hrvoje Piasevoli from Croatia describes 2 approaches for working with the 64-bit driver from SSIS:

Importing data from 64bit Excel in SSIS

Since the author's 2 workarounds are (1) the Import and Export Wizard and (2) OPENROWSET, not all users will find them completely satisfying. A solution that's more "native SSIS" would be preferable (but let's remember that this is an ACE and a Visual Studio limitation, not an SSIS limitation).

-Doug