Friday, April 20, 2012 9:34 AM
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 12:53 PM
Thursday, April 26, 2012 9:24 AMModerator
According to the error message, the issue is due to BIDS is a 32-bit application and can not load 64-bit stuff, please consider the following aolutiona to fix the issue,
1. Using the SQL Server Import and Export Wizard(Import and Export Data (64-bit)).
2. Using OLE DB Source in DataFlow with SQL Server as the Data Source.
For detail steps about how to fix it, please refer to the following article,
Importing data from 64-bit Excel in SSIS: http://hrvoje.piasevoli.com/2010/09/01/importing-data-from-64-bit-excel-in-ssis/
And here is a similar thread talked about the issue, please refer to:
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Wednesday, May 02, 2012 8:33 AM
Thursday, April 26, 2012 7:57 PM