Hi am having a problem with handling failed tasks. I have a loop container which contains a number of tasks which are executed in sequence. It is possible that a task might fail. Just now when a task fails the whole package comes to a halt. What i would like is, when a task fails a specified task gets executed and then the loop starts again. I am using SQL SERVER 2005 SSIS. I have set 'failpackageonfailure' and 'failparentonfailure' to false.

Can anyone help?

Thanks in advance.