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.'

  • 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.