Post reply

Acquired Connection method failed error code 0xC0014009

  • September 6, 2021 at 4:47 am

    #3927077

    Hi,

    We have a set of around 24 packages running on daily basis.

    Source - ODBC (hadoop db)

    destination - SQL server

    From past few days, we are getting following error on Source to Stage dataflow:

    We have scheduled 5 runs for the package before termination, so sometimes it fails to establish connection in first run but succeeds in next attempts.

    I tried running the package  after setting  32 bit true  and delay validation false as well.

    Any other pointers where we can check this?

  • September 6, 2021 at 9:52 am

    #3927132

    Are you saying that the package fails on its first run, but you don't want that to happen?

    Or are you asking for help diagnosing the connection issue?

    Please clarify.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • September 10, 2021 at 2:22 pm

    #3928572

    Yes, the package fails on the first run, but gets executed in second or third turn. We have both 64 bit and 32 bit ODBC drivers installed and all 24 packages were absolutely fine till last week.

  • July 27, 2023 at 2:10 am

    #4245542

    See if there is any patch or latest security updates happened, it may break ODBC connectivity using SSIS.

    You case may be odbc connection for mysql connector 8.0 (source) and sql server 2017 destination.

Viewing 4 posts - 1 through 3 (of 3 total)

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