Tuesday, April 15, 2014

Error: 0xC0209303 at Package, Connection manager "Excel Connection Manager": The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode.

The error might occur when you run the package  in the 64 bit environment, but when you test your connection, it says success.

Details error message : Error: 0xC0209303 at Package, Connection manager "Excel Connection Manager": The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.

The Reason is package is trying to run via 64 bit driver while running the package, so the solution is to make Run64BitRunTime = False.


Posted by at
Labels:

2 comments:

  1. KrisMarch 18, 2015 at 11:59 AM

    I was looking for this solution.
    Appreciate for posting such a good solution.

    I would appreciate if you could publish Errors encountered in SSIS and explain and post it it will help others.

    Thanks a lot

    ReplyDelete
  2. KrisMarch 18, 2015 at 12:00 PM

    If possible as and when you post please notify me by email and I would like to read and comment.
    Thanks a bunch

    ReplyDelete

Subscribe to: Post Comments (Atom)