Hi everyone,

going roundabout in SQLServerCentral.com I've found the article by Bradley Schacht:

http://www.sqlservercentral.com/blogs/bradleyschacht/2011/04/25/a-caution-about-checkpoints/[/url]

At the end in this article he states:

To recap:

Don’t expect checkpoints to work properly in parallel.

If a parallel task is RUNNING when another task fails, the package will rerun the non-failing task in addition to the failed task.

Don’t use checkpoints on containers if you want them to work correctly

If you put a checkpoint on a sequence container the failed task will be skipped the next time you run the package.

He seems to assert that we have to avoid the use of checkpoints with every type of container and not only the FOR LOOP and FOREACH LOOP containers. In contrast with Microsoft official docs (it wouldn't be the first time).

Any further information is welcome.