• First the answer to your question.....the procs will continue to run (i think) because once the are engaged by the ssis, even if SSIS completes, sprocs will continue.

    But i said, 'i think' above because few people would have faced this situation, not because the situation itself (ie identifying recs to be processed, processing them, inserting processing logs in a control table, writing a file after that ) is unique but because you have tried it in a unique manner. It seems you using SSIS ONLY for the 'loop'. You could easily have a outer proc calling all the 4 procs in a loop in sql also without involving SSIS.

    I would suggest a diff architecture.

    Do the 'sproc 1 ' in SSIS using conditional transform.

    Then call 'sproc2' in an execute sql task.

    Then maybe do the sproc3 part also in a dataflow task.

    Then push the data to a file by using available tasks(bulk insert, dataflow, lookups etc) etc to generate the file.

    Chain the above as a dataflow inside the ssis.

    Hope this helps.