|
How can I use Checkpoints while I am using For Each Loop containers in an SSIS package? Whenever I try and rerun the package it starts from the beginning of the foreach loop container instead of from where it failed. The checkpoint seems to have trouble with for each loop containers. I created a table insert to help me identify where it errored and then I remove the successful ones from the directory and restart it, but that's more of a work around. I would like it to just start from the failed directory and continue on. Any ideas?
(comments are locked)
|
|
Unfortuntely, the ForEach Loop container is treated as a single task container. For Books Online: The task host container, which encapsulates a single task, is the smallest atomic unit of work that can be restarted. The Foreach Loop container and a transacted container are also treated as atomic units of work.
(comments are locked)
|
