title: SSIS distributed Transactions Error "Failed to Acquire Connection
body: <p>I am using SSIS built-in transactions. Scenario is as following</p>
  
  <p>There are two databases on Same Server and I need to Merge them (INSERT/UPDATE)
  I am using SQL Merge Clause to do so. There are few Master Tables and each one has Couple of Child tables. Merge Statements Runs on Master Table first and then I have ExecuteSQL tasks for Child tables. Child Tables ExecuteSQL runs in Parallel. </p>
  
  <p>While doing this i am getting Failed to acquire connection and task fails on one of the parallel running ExecuteSQL tasks. Could not figure out what is the cause. </p>
  
  <p>RetainSameConnection is set to false and if i set it to True it gives "Transaction Context is in use by another session" Error.</p>
  
  <p>As i understand i don't need RetainSameConnection = True as It's only required in Local TSQL based transactions. DTC is enabled and working.</p>
  
  <p>NOT all tasks fails in my package and that suggests it succuessfully acquired the connection by somehow fails on Parallel tasks. </p>