Article ID: 2624458 - View products that this article applies to.
Consider the following scenario:
Note: This issue is not tied to Execute SQL Task. This may occur with other tasks as well.
This behavior is by design . The checkpoint data is not saved for the For Loop Container and Foreach Loop container items. If a child container in the loop runs successfully, it is not recorded in the checkpoint file. So, when the package is restarted, the tasks in each of these container items are executed again.
To work around the issue, wrap the For Loop or the Foreach Loop container inside a Sequence Container.
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.
Article ID: 2624458 - Last Review: October 3, 2011 - Revision: 2.0