Cannot Load Excel file through SSIS package deployed to SSMS

Question

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?

Answer 1

Hi @Lady Foley ,

There is no need to run SSIS packages on a SSIS run-time server in a 32-bit mode.

You need to downoad and install the Microsoft.ACE.OLEDB.12.0 64-bit on a server.
https://www.microsoft.com/en-us/download/details.aspx?id=13255

Here is a query to check if the Microsoft.ACE.OLEDB.12.0 64-bit is properly installed on the server:

EXEC master.sys.sp_MSset_oledb_prop;  

You should see it along the following:

Answer 2

Hi @Lady Foley ,

The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered

You may need to download the Access Database Engine 2010 64-bit.

Microsoft Access Database Engine 2010 Redistributable

Also take a reference of here, if you get error that you could not install the 64bit cause you have already the 32bit.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October