December 12, 2008 at 3:38 pm
Hi all,
I have 25 control flow tasks in a sequence container in my package which can run in parallel. I want to make use of SSIS check point in my package. Say for example, My package fails and 6 out of 25 control flows(CFs) completed successfully. I set to fail the parent on failure of any control flow which means my sequence container fails. But when I restart it,all the 25 CFs are executed again. The 6 CFs which were completed successfully during the first failure had their rows commited in the tables. So when I restart it the second time, those Cfs execute again doubling the number of rows in the table.
Does check points work within a sequece container? Any help or suggestion is greatly appreciated.
Thanks, Kayal
December 16, 2008 at 10:59 am
Ok - I figured out that checkpoints donot work well with parallel tasks. Thanks.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply