title: cannot connect to database after putting tasks in sequence container
body: <p>I had a package that worked perfectly until i decided to put some of its tasks inside a sequence container (More on why I wanted to do that - <a href="https://stackoverflow.com/questions/19867490/how-to-make-a-ssis-transaction-in-my-case">How to make a SSIS transaction in my case?</a>). </p>
  
  <p>Now, i keep on getting an error - </p>
  
  <pre><code>[Execute SQL Task] Error: Failed to acquire connection "MyDatabase". Connection may not be configured correctly or you may not have the right permissions on this connection.
  </code></pre>
  
  <p>Why could this be happening and how do I fix it ?</p>