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.
at

21 comments:

  1. AnonymousOctober 19, 2012 at 5:02 AM

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

    ReplyDelete
  2. Radu CFebruary 10, 2013 at 4:18 AM

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

    ReplyDelete
  3. kumarFebruary 10, 2013 at 4:53 AM

    Hi Radu,

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

    ReplyDelete
  4. AnonymousAugust 7, 2013 at 8:56 AM

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

    ReplyDelete
  5. AnonymousAugust 27, 2013 at 9:41 AM

    You 'da man.

    Thanks!

    ReplyDelete
  6. AnonymousSeptember 20, 2013 at 5:32 PM

    God Bless....You da Man.

    ReplyDelete
  7. AnonymousOctober 15, 2013 at 12:49 PM

    this was killing me - THANK YOU

    ReplyDelete
  8. kumarNovember 30, 2013 at 10:06 AM

    Glad to hear this from you...

    ReplyDelete
  9. UnknownDecember 5, 2013 at 3:31 PM

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

    ReplyDelete
  10. AnonymousMarch 19, 2014 at 10:43 AM

    Thank you, it is working.

    ReplyDelete
  11. David McAfeeApril 22, 2014 at 9:47 AM

    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
  12. AnonymousMay 9, 2014 at 6:52 AM

    Thanks .......... :-)

    ReplyDelete
  13. AnonymousAugust 14, 2014 at 7:58 AM

    Thanks! This helped me as well.

    ReplyDelete
  14. AnonymousOctober 30, 2014 at 9:26 AM

    спасибо

    ReplyDelete
  15. AnonymousNovember 26, 2014 at 3:44 AM

    Thank bro, u are god

    ReplyDelete
  16. JYUZENAugust 26, 2015 at 8:50 PM

    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
  17. UnknownOctober 9, 2015 at 9:28 AM

    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
  18. UnknownJanuary 13, 2016 at 12:43 PM

    Thank you

    ReplyDelete
  19. GAURAV MESSAGEMay 6, 2016 at 4:05 AM

    Thank you

    ReplyDelete
  20. NoneApril 23, 2018 at 8:27 AM

    Thank you - this still works!

    ReplyDelete
  21. UnknownSeptember 5, 2018 at 8:06 AM

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

    ReplyDelete

Subscribe to: Post Comments (Atom)

MYSQL::Setting Validate_Password componet for MySQL Database to ensure password policy settings

Inadequate Password Settings for MySQL Database We observed that the `validate_password%` settings on hostname `<insert hostname>` a...