When you don’t have Microsoft Office 2007 installed on a machine running Microsoft SQL Server 2008 R2 Integration Services, you might get the error "The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered"
Solution
To fix this problem:
Download and install the ACE provider from the following link, this supports office 2007 files both xls and xlsx file.
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
Error
TITLE: Microsoft Visual Studio
——————————
Error at Org_eenheden [Connection manager "Excel Connection Manager"]: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
Error at Load data into SA [Organisatie eenheden [1]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209302. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
——————————
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)
——————————
BUTTONS:
OK
——————————
Screendump
Thanks! It helped me a lot 🙂