When working with an Excel data source one may encounter error messages that indicate the Microsoft ACE OLE DB provider is not registered.This error can be presented in many forms. The following are a few examples of such error messages:
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". The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. For more information, see http://go.microsoft.com/fwlink/?LinkId=219816. SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Data Source Forecast_Sales" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
The following steps should be tried in the following order until the issue is resolved.
1. Make sure the Jet Data Manager and Excel have the same bit-rate. For example if Excel is 32-bit you will need to install the 32-bit version of the Jet Data Manager. If Excel is 64-bit you will need to install the 64-bit version of the Jet Data Manager.
2. Install Microsoft Access Database Engine 2010 Redistributable. These components can be found here: Microsoft Access Database Engine 2010 Redistributable
3. Install 2007 Office System Driver: Data Connectivity Components. These components can be found here: 2007 Office System Driver: Data Connectivity Components