How to control sequence of tasks inside a data flow in SSIS?
<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>