title: how to use CheckPoint For loop container in SSIS
body: <p>Long story short, checkpoint doesn't work for for-loop-container.</p>
  <p>We're trying to use for loop containers when doing ETL process. For example we used @CounterNumber to loop, and EvalExpression is @CounterNumber &lt;=5.</p>
  <p>However, if it failed on the second round, even if the CheckPointFile captured that @CounterNumber = 2, but it's still restart the for loop from begining.</p>
  <p>Does anyone know how to restart the for loop container from last failure?
  I heard that we could use variables in InitExpression instead of static value, but I don't know how to do that.</p>