title: Can SSIS execute tasks in specific order?
body: <p>I am in process of creating an ssis package that need to do following in specified order:</p>
  <ol>
  <li>process some data</li>
  <li>move that data to some other tables</li>
  <li>Get some data and push it in a plain text file.</li>
  </ol>
  <p>I have created 3 store procedure for these, I have 2 &quot;Execute SQL tasks&quot; for 1 and 2 and a &quot;Data Flow task&quot; for 3rd.</p>
  <p>Now when i run the package i can see all 3 step are completed (no errors) but they are not running in correct order.</p>
  <p>I see step 3 is run first then step 1 and 2, i think then step 3 runs again. Normally i can ignore it but as the data in the text file can be 700 mb, i need to find a way to get SSIS to run these task in sequence.</p>
  <p>I have tried &quot;Sequence Container&quot; but no luck.</p>
  <p>Can some one help me with this please?</p>
  <p>KA</p>