Hello

I have turned off all 'fail on task' steps. I have turned off fail 'package on first error' on the parent package. I have turned on fail package on first error on the child package. I have also tried a number of combinations. in the child and parent packages The child packages call stored procedures that invoke RAISERROR when something bad happens, yet no error causes the parent package to fire the OnFailure event

Can someone help?

Thanks!

OK

So this works for me.

CHILD

I have a proc which I execute

CREATE PROCEDURE Raise_My_Errors
AS
RAISERROR ('I am raising an error', 16, 1) WITH NOWAIT
go

I add a connection and ExecuteSQL task that just fires this proc


PARENT

ExecutePackage task - Fires the child
On Failure workflow to an ActiveScript task.

Runs:

1. If in the CHILD I set "Fail Package on first Error" but not in the
parent then the workflow is followed
2. If in the CHILD I do not set "Fail Package on first Error" and also not
in the parent then the workflow is not followed but the ExecutePackage task
fails with my RAISERROR message
3. If in the CHILD I do not set "Fail Package on first Error" but set it in
the parent then the workflow is not followed but the ExecutePackage task
fails with my RAISERROR message
4. If in the CHILD I set "Fail Package on first Error" and in the parent
then the workflow is not followed and the ExecutePackage task fails with my
RAISERROR message.



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

package on first error on the child package. I have also tried a number of
combinations. in the child and parent packages The child packages call
stored procedures that invoke RAISERROR when something bad happens, yet no
error causes the parent package to fire the OnFailure event.

Does q article 810185 have any bearing here? Thanks for the terse help!

I can't seem to see the thread for this, so trying to take a look at the KB
anyway I find it does not exist.

Sure that is the number ?



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

Fail on first error needs to be set in the child package only. This will
prevent any on error workflow being followed, since it really does fail the
package when it errors, so nothing else is done.

You mention and error -handling SQL task, in the singular. Multiple
constraints to a single step must ALL be satisfied for the step to execute.
So having one task with lots of failure constraints leading too it will not
work.

Make sure your global variable names are consistent, as these are case
sensitive.


--
Darren Green
http://www.sqldts.com


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

dynamically determines the file name of a text file to import into sql
server. Some of the sql tasks execute procs, some execute sql. NONE of the
tasks in the package fire the error-handling sql task (which just does a
table update), even if I raise an error in a task or force an error. The
package is executed by a VB.Net application.