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.

10 Comments


  1. After study a few of the weblog posts on your web site now, and I truly like your way of blogging. I bookmarked it to my bookmark website record and will be checking back soon. Pls try my website as nicely and let me know what you think.

  2. I appreciate, cause I found just what I was looking for. You’ve ended my four day long hunt! God Bless you man. Have a nice day. Bye

  3. Your means of describing everything in this particular paragraph is in reality fastidious, everyone have the capacity
    to without difficulty know it, Thanks a good
    deal.

  4. Great Blogpost! Thanks for sharing your info. I really appreciate your efforts and I will_ be waiting for your further write ups thank you once again.

Leave a Reply

Your email address will not be published. Required fields are marked *