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: 246693 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:

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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: 110639 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)