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).