SQL Server 2012 SSIS - ACE.OLEDB.12.0 64-bit Issue


If you get the following error -

Microsoft.ACE.OLEDB.12.0 provider is not registered...


You can install 64 bit version of Office 2010 and it will fix the issue. If you have 32 bit version installed, uninstall it first and then install 64 bit version. It worked for me.