Re: Child Package Errors Do Not Fire OnFailure in Parent

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 05/11/04 

Date: Tue, 11 May 2004 08:16:12 +0100

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@discussions.microsoft.com> wrote in message
news:BC5B323A-1911-4264-9AF2-4F9E91E996F0@microsoft.com...
> 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!

Relevant Pages