Search code examples
ssissql-server-2012business-intelligence

SSIS: Restarting whole container while using checkpoints


I am implementing checkpoints with some special cases. My package contains a sequence container, which is having a script task and a foreach loop. Whenever package fails in foreach loop, it restarts from foreach loop but I wish to execute from the beginning of the container in case of failure.

My container looks like this: enter image description here

Any ideas how to accomplish this? EDIT: I tried setting failparentonfailure property to true, but it doesnot seem to work. If the task fails in the foreach loop, it won't run the script upon restart.


Solution

  • Developed a workaround by using foreach loop (that runs a single loop) instead of sequence container. Since checkpoint data is not stored for loops, it runs all the tasks inside once again.