When i trying to load data from MS access (MDB) to SQL ,i am
getting the below error.
Error: 0xC0209303 at Package, Connection manager "mdbfilename": SSIS Error Code
DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The
requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered -- perhaps
no 64-bit provider is available. Error
code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service
Components" Hresult:
0x80040154 Description: "Class not
registered".
Error: 0xC020801C at Data Flow Task mdbfilename, OLE DB Source [1]: SSIS Error Code
DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the
connection manager " mdbfilename
" failed with error code 0xC0209303. There may be error messages posted before this
with more information on why the AcquireConnection method call failed.
Error: 0xC0047017 at Data Flow Task mdbfilename,
SSIS.Pipeline: component "OLE DB Source" (1) failed validation and
returned error code 0xC020801C.
Resolution:
It seems that SSIS project are now on a 64 bit machine. And
that there is no 64 bit OLE DB provider Microsoft.Jet.OLEDB.4.0.So the fix
is in running this project under 32 bit modes
Go to the SSIS project properties page
à Then Click Debugging under configuration
properties
à Select “Run64BitRuntime” property to false
à Save the project
->RUN Build again
à Then check the package runs to a successful
completion.
That's it.