Connect to xlsx file


  • Environment

    Windows Server 2008 R2

    SQL Server 2008 R2 - (EE)

    I need to connect to excel 2007 files. I downloaded the Microsoft Access Database Engine 2010 Redistributable from this link

    I installed the 32 bit to develop. I am able to design the package and run the package.

    I deployed the package where I installed the 64 bit version of the Microsoft Access Database Engine 2010 on similar environment.

    Now when I run the package I get error Microsoft.ACE.OLEDB.12.0 is not registered. and the acquire connection method failed.



    Friday, April 20, 2012 9:34 AM


All replies