March 31, 2010 at 10:41 am
Hi All,
Setup
-----
Windows xp (64 bit)
Sql server developer edition (64 edition)
use to import excel file thru ssis by setting project properties debug options-> run64runtime -> false.
it runs successfully so far( past 6 months)
but i do no what went wrong ...it throwing following error message when i try to select name of excel sheet.
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
theres msjet40.dll file both in (system32 & syswow64 folder)
pl let me know how to fix this..bcoz it was running successfully with same setup so far.
March 31, 2010 at 11:10 am
Something's changed - you're just not sure what it is!
You could try using RegSvr32 to register these DLLs:
C:\WINNT\System32\Msjetoledb40.dll
C:\WINNT\System32\Msjet40.dll
C:\WINNT\System32\Mswstr10.dll
C:\WINNT\System32\Msjter40.dll
C:\WINNT\System32\Msjint40.dll
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply