title: Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection
body: <p>I am getting following error while attempting to execute the package. I can execute individual task successfully. But whenever attempt to execute whole package it gives me error. 
  <strong>SSIS Data flow on distributed transaction - [Execute SQL Task] Error: Failed to acquire connection "targetCon2". Connection may not be configured correctly or you may not have the right permissions on this connection.</strong></p>
  
  <p>I went through many links but nothing worked for me so starting a new thread. I checked <a href="https://stackoverflow.com/questions/1687084/sql-agent-job-connection-may-not-be-configured-correctly-or-you-may-not-have-t">SQL Agent Job - Connection may not be configured correctly or you may not have the right permissions on this connection?</a></p>
  
  <p><a href="https://stackoverflow.com/questions/11957391/ssis-package-fail-due-to-acquire-connection-error">SSIS package fail due to &#39;acquire connection&#39; error</a></p>
  
  <p><a href="https://stackoverflow.com/questions/3119867/ssis-package-failing-with-failed-to-acquire-connection-error">SSIS Package failing with &quot;Failed to acquire connection&quot; error</a></p>
  
  <p>My distributed transaction service is running. DTC settings are correct. I am executing everything sequentially. Don't know whats wrong. I want to execute whole part in one transaction.</p>
  
  <p>Please check the screenshots for more details.
  <a href="https://i.stack.imgur.com/CuaMl.png" rel="noreferrer"><img src="https://i.stack.imgur.com/CuaMl.png" alt="Project Snap and Error"></a></p>