title: SSIS wait until execute process task completes
body: <p>I have an ssis package that has two objects: execute process task and Dataflow task.</p>
  
  <p>The execute tasks runs an .exe that inserts data into my sql data(it is a lengthy process). This process needs to complete before the next tasks starts. However, while the .exe is running, it fires off a success value(eventhough it is not done) which executes the next task. How can I make the dataflow task wait?</p>