none
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

    Question

  • Hi All,

    I'm developing a package on the development server to load data from Excel. I created excel connection manager and when i tried to use the 'Excel Source' in the dataflow task. I'm getting the following error:

    The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

    What i did was i downloaded and installed the drivers from the following link

    http://www.microsoft.com/en-us/download/details.aspx?id=13255

    I restarted the server and still i'm getting the same error, can anyone please point where i'm going wrong? Have i downloaded the wrong set of drivers/

    Server Information:Windows Server 2008 R2,SP1

    Thanks

    Tuesday, May 14, 2013 11:03 AM

Answers

  • Thanks Russ and Koen i downloaded for 64 bit OS, so should i now download the drivers for 32 bit instead?

    Yes. BIDS is a 32-bit application, so you need the 32-bit providers installed in order to develop a package.

    MCSA SQL Server 2012 - Please mark posts as answered where appropriate.

    • Marked as answer by PMunshi Tuesday, May 14, 2013 1:18 PM
    Tuesday, May 14, 2013 12:21 PM

All replies

  • Are you running this on a 64bit OS?  You will need to change to use 32 bit mode. http://www.bidn.com/blogs/ShawnHarrison/ssis/2362/ssis-basics-running-a-package-in-32-bit-mode and http://msdn.microsoft.com/en-us/library/cc280527.aspx 


    Russel Loski, MCT, MCSA SQL Server 2012, 2008, MCITP Business Intelligence Developer and Database Developer 2008 Twitter: @sqlmovers; blog: www.sqlmovers.com

    Tuesday, May 14, 2013 11:08 AM
  • Did you install the 32-bit or the 64-bit version of the provider?

    In order to develop SSIS packages in BIDS/SSDTBI you need to install the 32-bit provider on the development machine.


    MCSA SQL Server 2012 - Please mark posts as answered where appropriate.

    Tuesday, May 14, 2013 11:37 AM
  • Thanks Russ and Koen i downloaded for 64 bit OS, so should i now download the drivers for 32 bit instead?

    Tuesday, May 14, 2013 12:20 PM
  • Thanks Russ and Koen i downloaded for 64 bit OS, so should i now download the drivers for 32 bit instead?

    Yes. BIDS is a 32-bit application, so you need the 32-bit providers installed in order to develop a package.

    MCSA SQL Server 2012 - Please mark posts as answered where appropriate.

    • Marked as answer by PMunshi Tuesday, May 14, 2013 1:18 PM
    Tuesday, May 14, 2013 12:21 PM
  • Thanks Russel I already did what was shown in the link you have posted, but that didn't work for me.

    Tuesday, May 14, 2013 12:23 PM