failure precedence

Question

failure precedence

arkiboys

Hall of Fame

Points: 3958
More actions
October 7, 2017 at 8:12 am

#325785

Hello,
Package has several tasks connected to each other...
I am introducing a failure precedence so I set the task1 to fail so on failure task2 gets called.
When task1 fails then task2 (execute sql task - select 1) fails also.
do you know why task2 fails? the error seems to be referring to connection whereas all tasks have the same connection and everything is fine until I introduce the failure task.
Thank you

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

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

Phil Parkin SSC Guru Points: 246956 More actions · Answer 1

arkiboys - Saturday, October 7, 2017 8:12 AM
Hello,
Package has several tasks connected to each other...
I am introducing a failure precedence so I set the task1 to fail so on failure task2 gets called.
When task1 fails then task2 (execute sql task - select 1) fails also.
do you know why task2 fails? the error seems to be referring to connection whereas all tasks have the same connection and everything is fine until I introduce the failure task.
Thank you

That is not the behaviour I see:

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

arkiboys Hall of Fame Points: 3958 More actions · Answer 2

Phil Parkin - Saturday, October 7, 2017 8:25 AM
arkiboys - Saturday, October 7, 2017 8:12 AM
Hello,
Package has several tasks connected to each other...
I am introducing a failure precedence so I set the task1 to fail so on failure task2 gets called.
When task1 fails then task2 (execute sql task - select 1) fails also.
do you know why task2 fails? the error seems to be referring to connection whereas all tasks have the same connection and everything is fine until I introduce the failure task.
Thank you
That is not the behaviour I see:

Hello, in my case, according to your example, sql 3 fails also. I can not figure out why.

sgmunson SSC Guru Points: 110640 More actions · Answer 3

arkiboys - Saturday, October 7, 2017 8:32 AM
Phil Parkin - Saturday, October 7, 2017 8:25 AM
arkiboys - Saturday, October 7, 2017 8:12 AM
Hello,
Package has several tasks connected to each other...
I am introducing a failure precedence so I set the task1 to fail so on failure task2 gets called.
When task1 fails then task2 (execute sql task - select 1) fails also.
do you know why task2 fails? the error seems to be referring to connection whereas all tasks have the same connection and everything is fine until I introduce the failure task.
Thank you
That is not the behaviour I see:
Hello, in my case, according to your example, sql 3 fails also. I can not figure out why.

Without any details on what task 1 and task3 actually do, there's no conceivable way we're going to be able to do more than make ridiculously wild guesses. Exactly what do these two tasks do, and don't spare the details.

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)