Blog Pages

SSIS Excel Connection Manager 64-bit error

Error message:
[Connection manager "XXX Excel Connection Manager"] Error: The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".

Solution:
Right click on the project name à properties

Configuration Properties à Debugging: Set Run64BitRuntime to False.

No comments:

Post a Comment