title: Acquire Connection and Strange behavior when using Execute Package Task
body: <p>I've a Master package where in I'm calling several packages using Execute package task. </p>
  
  <p>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. </p>
  
  <p>Also the packages have encrypt sensitive with the password. </p>
  
  <p>Strange behavior seen:
  1. Child Packages run successfully when run from BIDS but fail when run from master packages with Acquire Connection failure </p>
  
  <p>"The AcquireConnection method call to the connection manager failed with error code 0xC0202009"</p>
  
  <p>Can someone help with the resolution for this?</p>