• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 28
  • Last Modified:

SSIS error

We have a SSIS package run in SQL 2012 and see below error message:

The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered.
If the 32bit driver is not installed, run the package in 64-bit mode.

Where can I see if Microsoft.ACE.OLEDB.12.0 is installed on the server and if it's 32bit or 64bit?
Thanks a lot!
0
xuewei shi
Asked:
xuewei shi
3 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
That driver belongs to MS Access 2010 but I think is needed by any MS Office application. Are you trying to Import/Export from any Access or Excel file? If so you'll need the respective client and you can download it here.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered.
Tell us what your connections are.  When everything else in the world was being converted to 64-bit, SSIS and various drivers stayed at 32-bit, causing compatibility issues like this.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If the download from Vitor does not work, then you might try this one:

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

It's for 2007, but I've used it on systems where I needed to work with .accdb files of any version.
0
 
xuewei shiDBAAuthor Commented:
Thanks guys, I downloaded and installed the file from Vitor's link, and it solved the problem!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now