title: How to control sequence of tasks inside a data flow in SSIS?
body: <p>I am creating an SSIS package, it has one execute SQL task and one data flow task.</p>
  
  <p>In the data flow task, the data is moved from from different source tables to the respective target tables.</p>
  
  <p>Can we control the order in which the ETL execution takes place, so that each table transformation completes before the next one starts?</p>
  
  <p>I don't want to create multiple packages, need to handle it one package. </p>
  
  <p>For e.g., in the data flow task, we have the below code executing:</p>
  
  <ul>
  <li>S1->data conversion transf->T1</li>
  <li>S2->data conversion transf->T2,</li>
  <li>S3->data conversion transf->T3,</li>
  <li>S4->data conversion transf->T4,...................</li>
  </ul>
  
  <p>And the data load sequence must be as follows:</p>
  
  <ul>
  <li>S1->data conversion transf->T1,</li>
  <li>S4->data conversion transf->T4,</li>
  <li>S3->data conversion transf->T3,</li>
  <li>S2->data conversion transf->T2,...............</li>
  </ul>
  
  <p>Please let me know how to achieve it.</p>