Acquired Connection method failed error code 0xC0014009

  • 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?

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

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

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

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

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