Hi

In my DTS package i have "Truncate Table task" followed by "Package Success"
and "Package Failure" tasks.

"Truncate Table task" is connected to "Package Success" using "On Success"
workflow.
"Truncate Table task" is connected to "Package Success" using "On Failure"

When there is a error (say wrong stored proc) in the "Truncate table" task ,
the "Package Failure" is not executing.

How to resolve this ?

Actually I have 3 workflows (On failure) as input to the "Package Failure".
If i have 1 workflow it is working.

"Kandachar" wrote:

Ahh, this one got me too until I stumbled upon the answer in books online...
If you have three workflow arrows pointing to a step, then they are "anded"
together. That is, in your case, all three of the "from" steps must fail for
the "to" step to be executed. Makes the workflow sequencing not very useful
IMHO, but that's the way it works.

Now, I have not tried this, so can't vouche for how well it works, but
here's an article on how to make sequencing behave like you expect (any
failure routes to the failure step)

http://www.sqldts.com/default.aspx?218

Good luck.

Lamont Adams
MCP

"Kandachar" <Kandachar (AT) discussions (DOT) microsoft.com> wrote