title: SSIS Control Flow - set a precedent constraint on entire group of Data Flow tasks
body: <p>I have about 20 data flow tasks arranged into a group in my control flow window. I'm fine with them executing in parallel; in fact I prefer it. </p>
  
  <p>But I need to add an Execute SQL Task and I need it to run completely before any of my data flow tasks begin.  It doesn't look like I can connect a precedence constraint from the Execute SQL Task to the group of data flow tasks (I was really hoping it would be that easy.)</p>
  
  <p>Is my only option to create a precedence constraint from my Execute SQL Task to EACH of the data flow tasks?  Seems like there should be a simpler solution.  </p>
  
  <p>(SQLServer 2005)</p>