SSIS ACE.OLEDB.12.0 Driver issue We have a SSIS package which is using a Excel destination. It was brought to my notice that the job was failing with the common error message 'Microsoft.ACE.OLEDB.12.0' is not registered. I checked the server and could locate this driver in the registry. I exported the package into my local and execute it and it ran successfully. I thought of checking to rebuild the package again and test it from the server. Is there any other idea/solution? Please suggest.
A common cause of this problem can be the difference between 32 bit and 64 bit installations.

If your SSIS package is running in 64 bit the Access driver needs to be installed in 32 bit too.

My guess would be that on your machine you installed the 64 bit driver, but on the server the 32 bit driver has been installed.

You could test this by executing the package from the 32 bit dtexec found here:

C:\Program Files (x86)\Microsoft SQL Server\&lt;version&gt;\DTS\Binn


And trying to execute it from the 64 bit dtexec found here

C:\Program Files\Microsoft SQL Server\&lt;version&gt;\DTS\Binn


See the documentation for more information dtexec Utility (SSIS Tool)

Then it's just a matter of installing the correct drivers (32 or 64 bit)