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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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