Wednesday, October 10, 2012

SSIS2008R2 Error: 0xC0209303 at Package:



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.

21 comments:

  1. Thanks, Kumar. I was experiencing the error you described above and your resolution fixed the problem.

    ReplyDelete
  2. Hey man. Thanks a lot, you solved my problem:)

    ReplyDelete
  3. Hi Radu,

    you are welcome !!!!!!!!!!

    ReplyDelete
  4. Thank you , saved me quite a bit of time ;)

    ReplyDelete
  5. You 'da man.

    Thanks!

    ReplyDelete
  6. God Bless....You da Man.

    ReplyDelete
  7. this was killing me - THANK YOU

    ReplyDelete
  8. Worked for me in development of an SSIS package, The error code was no help at all.

    ReplyDelete
  9. Thank you, it is working.

    ReplyDelete
  10. Thank you. It was driving me nuts how I could preview the data in the connection manager but the SSIS would fail. Your simple instructions have me working again.

    ReplyDelete
  11. Thanks .......... :-)

    ReplyDelete
  12. Thanks! This helped me as well.

    ReplyDelete
  13. Thank bro, u are god

    ReplyDelete
  14. Thank you!
    I was saved by this tips, when I tried to upload an excel file to a table in SQL server DB through SSIS.
    SSIS is great tool, but, often encounter issues which confuses me.

    ReplyDelete
  15. Thank you very much , it is so easy but yet it is so hard to find this solution. I appreciate this answer. Saved me lot... Taner Kanbir

    ReplyDelete
  16. Thank you - this still works!

    ReplyDelete
  17. Thank you! Have been trying to figure that out for weeks!

    ReplyDelete

MYSQL:::Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables

  Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...