Post reply

Allow Task to Fail but carry on

  • April 17, 2009 at 4:20 am

    #131298

    I have a For Each Loop container. It loops through a list of Excel files. All the files _should_ have the same structure. Within the container I have a file system task to copy each file to a fixed location, then I have a data flow task to load from excel to sql.

    My problem is that if one of the Excel files has a different structure to expected the data flow task fails (fine) but this also fails the For Each container. So following an error no further Excel files are loaded and the whole package fails

    What would be the best way of allowing one or more executions of the data flow task to fail but to carry on looping through the file list and prevent the package from failing.

    Thanks

    Allen

  • April 17, 2009 at 10:04 am

    #979778

    I am not sure if this is a bug or intentional behavior in SSIS that any tasks placed in the Sequence Container report success even if they fail. Now, this may not be the same case with the ForEach loop. Try setting the "Maximum Errors" to a finite value like 10 and also set the "Fail Parent on Failure" and "Fail Package on Failure" both to "False" on the tasks (if they were not already so) being executed in the For Each loop.

    Try it and let me know how it goes.

  • April 17, 2009 at 10:04 am

    #979779

    name of the Maximum Errors property is "MaximumErrorCount"

  • April 20, 2009 at 9:25 am

    #980799

    Thanks Vishal - I shall.

Viewing 4 posts - 1 through 3 (of 3 total)

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