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, 2009 at 05:10 PM in Default

avatar image

John Dunleavy
1 1 1 2

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

1 answer: sort voted first

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, 2009 at 11:36 PM

avatar image

Lynn Pettis
275 2 5

(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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Dec 05, 2009 at 05:10 PM

Seen: 2904 times

Last Updated: Dec 06, 2009 at 02:35 PM

Copyright 2018 Redgate Software. Privacy Policy