SSIS Execute Package task fails to Acquire Connection

  • facticatech

    Ten Centuries

    Points: 1302

    down vote favorite

    I've a Master package where in I'm calling several packages using Execute package task.

    Both child and master packages don't have any configuration and are connecting OLEDB (SQL Server) using hardcoded SQL authentication connections in the connection managers.

    Also the packages have encrypt sensitive with the password.

    Strange behavior seen: 1. Child Packages run successfully when run from BIDS but fail when run from master packages with Acquire Connection failure

    "The AcquireConnection method call to the connection manager failed with error code 0xC0202009"

    Can someone help with the resolution for this?

  • Koen Verbeeck

    SSC Guru

    Points: 258890

    Where are the child packages stored, in MSDB or on the filesystem?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • facticatech

    Ten Centuries

    Points: 1302

    All of them are stored in MSDB

  • Koen Verbeeck

    SSC Guru

    Points: 258890

    Can you post the full output of the output window?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • anubhajoshi1983

    Valued Member

    Points: 62

    Hi Experts,
    I know its an old post but i couldn't find the answer in the thread. I am facing the same issue and child package fails when runs through master package throwing error"The AcquireConnection method call to the connection manager failed"
    The child package is using ODBC connection String.

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

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