Connect to xlsx file
-
Friday, April 20, 2012 9:34 AM
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
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255
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.
Thanks
Dharmbir
All Replies
-
Friday, April 20, 2012 12:53 PM
Try this:
http://www.codesuck.com/2011/07/reading-excel-files-into-ssis-on-64-bit.html
MCTS, MCITP - Please mark posts as answered where appropriate.
-
Thursday, April 26, 2012 9:24 AMModerator
Hi Dharmbir,
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:
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/5a360a46-cf1e-45fa-8974-37caaaa5d3fc/
Thanks,
Eileen- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Wednesday, May 02, 2012 8:33 AM
-
Thursday, April 26, 2012 7:57 PMDhambir, I see you unproposed the article I linked to as answer.
Could you post what issues you are still struggling with?MCTS, MCITP - Please mark posts as answered where appropriate.
.png)
