Error: 0xC0209303 in SSIS

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.

1

Click on properties.

2

Select ‘Debugging’ and change ‘Run64BitRuntime’ to ‘False’.

3

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.

Article by Mustafa Toroman

I’m System Engineer at Authority Partners. I love to test and explore new technologies. Have over 20 active MS certificates such as MCSA for Windows Server and SQL Server, MCSE Private Cloud, Data Platform, Business Intelliegence and Server Infrastracture. Lately most interested in BI and Azure solutions. MCT since 2012. From 2016 MVP for Microsoft Azure.

Comments are closed.