August 11, 2012 at 12:50 pm
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?
August 13, 2012 at 12:44 am
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
August 13, 2012 at 3:46 pm
All of them are stored in MSDB
August 16, 2012 at 12:13 am
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
May 2, 2018 at 10:16 am
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply