x

How to use checkpoints with foreach loop containers in ssis

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?

more ▼

asked Dec 05 '09 at 05:10 PM in Default

John Dunleavy gravatar image

John Dunleavy
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort newest

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.

more ▼

answered Dec 09 '09 at 11:36 PM

Lynn Pettis gravatar image

Lynn Pettis
275 3

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1936
x900

asked: Dec 05 '09 at 05:10 PM

Seen: 2051 times

Last Updated: Dec 06 '09 at 02:35 PM