Script task fails, makes Job fail

  • Hi

    I have a package in witch I use a script task.

    Inside the script task I fail or succeed the Dts.TaskResult according to a certain predefined criteria.

    I then use the failed or succeeded task result for branching in the package.

    The problem that I am having is that when the script task does fail the package branches perfectly, but, when I run the package as a job the package fails because the script task returned a failed taskresult. (Description: The Script returned a failure result)

    Is there anyway to get past this and to make the package fail gracefully.

    Any help would be appreciated.

  • An easy way round this to set a package variable within your script task and then use precedence constraints to direct the flow afterwards based on the contents of the variable - leave the script task as completing successfully.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Thank you

    I will look into this!

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

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