Today I was working on importing some data to DWH with SSIS packages. So I remembered problem that was giving me big headache back in days. I spent few days then resolving 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”.
This error was related to importing data from Fox DB but later I found same error when importing from Access. It’s related in general with data sources that have 32-bit platform.
So this time I knew how to resolve it right away but it gave me idea to write about it as it took me long time to resolve this error first timeI encountered it.
So here is resolution:
Right click on your project in Solution Explorer.
Click on properties.
Select ‘Debugging’ and change ‘Run64BitRuntime’ to ‘False’.
And that’s it. It kind of looks too simple now, but when I was trying to solve that error, I really didn’t know what to do for days. Hope it helps someone.