I've created an SSIS package that loads an Excel file to an SSMS with no problems.
When I deploy the package to SSMS and run the package from there I get the below error -
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".
I've tried absolutely everything to fix this.
I've downloaded the 32 bit AccessDatabaseEngine.exe and changed the SSIS package to run in 32 bit mode and also changed it in SSMS to run in 32 bit mode.
Just to be sure I also tried all of this but with 64 bit versions ..... still the same error.
My Excel, SSMS and Visual studio are all 32 bit. When looking at my system through Control Panel > System, my system type is 64 bit.
Is there any way at all I can get this working through SSMS? I've exhausted the internet for solutions. Can anybody help?