July 7, 2013 at 8:34 pm
My source file was created in Excel 2007, so i had to install ACE drivers on server (I did it before in windows server 2003 but never had any issues), but now after installing ACE drivers i m getting following message when i debug the SSIS
The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local Machine
Retry using same user Id and password
Retry using new user Id and password
I installed ACE driver on windows server 2008
July 7, 2013 at 10:53 pm
Where are you executing the package?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 7, 2013 at 11:51 pm
I am executing package from the server where ACE drivers are installed
July 7, 2013 at 11:57 pm
Not sure, but this may be a 32/64-bit issue. Can you try running the package in 32-bit mode and see whether that helps?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 8, 2013 at 8:04 am
Ran package under 32 bit mode, didn't work....Any other suggestions???
July 8, 2013 at 8:43 am
From the reading I've done, there are a number of different scenarios that can lead to this message. I've found the following article to be helpful: MSDN Social: HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine[/url]. It may or may not be helpful for your situation. The author addresses one approach to fixing the error. Several other approaches are discussed in the lengthy comments section.
July 10, 2013 at 3:56 am
see if this link helps you - Microsoft OLE DB 12.0 Provider Not Registered
:rolleyes:
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply