Post reply

he AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009

  • December 12, 2016 at 4:33 pm

    #324041

    Good Evening ladies and Gents,

    I am getting the error message below within an SSIS package that i have created.

    [Bookings [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    I understand that excel connections cannot work in 64-bit mode, and have changed the option to false, however the issue persists.

    Is there anything else i can try?

  • December 12, 2016 at 4:37 pm

    #1917493

    Solution found.....Close the package and reopen....

    maybe working at 23:30 isnt such a good idea

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply