i have about five tasks in a for each loop container.. i would like to set a check point in all the five task within a container. question: If one of the tasks in the container fails, will check point resume from that particular task or from beginning of the container??suggest pls. i am using 2008r2

i have about five tasks in a for each loop container.. i would like to set a check point in all the five task within a container. question: If one of the tasks in the container fails, will check point resume from that particular task or from beginning of the container??suggest pls. i am using 2008r2 It is not possible to use checkpoints within the For Each Loop and the For Loop containers. This is because SSIS does not keep track of the number of iterations the loop has gone through during processing.Arthur My Blog

Arthurz i saw this article and it says we can http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/65809/

Hi Dilip, ArthurZ is right, I go through the link that you provided, and there is a paragraph as below: In a Foreach Loop, the control flow is repeated for every member of an enumerator, or collection. However, neither the information about the state of the enumerator, nor about the number of iterations the loop has gone through, is saved to the checkpoint file. This means that Foreach Loops will always iterate through all items in the enumerator, even when checkpoints are enabled. Here are some of the key points from this article. 1. Variables of type Object are never saved to the checkpoint file. 2. Although variable values are saved in the checkpoint file, those values are not used in the expressions of a For Loop or Foreach Loop. 3. A For Loop and a Foreach Loop will always be re-evaluated, even when checkpoints are enabled. Thanks, Eileen