Home Forums SQL Server 2012 SQL 2012 - General SSIS and Excel - 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.' RE: SSIS and Excel - 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'
call.copse
SSCoach
Points: 17960
More actions
April 24, 2015 at 3:43 am
#1793210
I actually managed to resolve this in the end, the package needed to be executed (debugged) in 32 bit mode.
http://sqlblog.com/blogs/john_paul_cook/archive/2010/03/24/running-32-bit-ssis-in-a-64-bit-environment.aspx
HTH.