We have a SSIS package run in SQL 2012 and see below error message:
The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered.
If the 32bit driver is not installed, run the package in 64-bit mode.
Where can I see if Microsoft.ACE.OLEDB.12.0 is installed on the server and if it's 32bit or 64bit?
Thanks a lot!