August 30, 2010 at 4:39 am
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.
August 30, 2010 at 4:46 am
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
August 30, 2010 at 4:52 am
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