Post reply

Continue the for each looping even when there is a failure in a task in the loop

  • December 24, 2008 at 3:05 pm

    #133300

    Hi,

    I have a for each loop which processes multiple files. If there is a failure in one of the tasks when processing one of the files, the package fails. Is there a way i can skip the processing of a file when it fails and continue the for each loop for the next file.

    Thanks & Regards

    Naveen

  • January 22, 2009 at 12:00 pm

    #931364

    First you have to create a CheckPoint with extension .XML and change the properties. As the image:

    You must set the Sequence Container FAILPACKAGEONFAILURE property = TRUE and also all the objects that are within the Sequence Container with FAILPACKAGEONFAILURE = TRUE.

    Att.

    Sandro Amaral

    ETL Developer

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply