RE: Child Package Wont Fail Parent

From: HWUK (HWUK_at_discussions.microsoft.com)
Date: 11/03/04 

Date: Wed, 3 Nov 2004 05:13:03 -0800

No matter the result of the child package the package task in the parent will
always show a success (apart for times that the child dosn't exist) because
it has run it. A solution would be for the child to generate a global
variable indicating its result and hte parent using it to decide wheter to
contine or not.

"Blair" wrote:

> I have gone through quite a number of threads where people had similar
> problem: parent package calls child package, a step in child fails,
> child completes anyway, parent doesnt fail.
>
> As per the other threads, I have set the following logging properties:
>
> In child package / package properties / logging tab:
> - Fail Package on First Error
>
> In parent package / execute package task / workflow properties /
> options:
> - Join Transaction if Present
> - Rollback Transaction on Failure
>
>
> The issue doesnt go away, though. Parent/child still happily
> completes.
>
>
> ....I've also iterated and tried a number of additional things
> including:
> - Execute on Main Package Thread (in parent / workflow prop / options)
> - Fail Package on First Error (in parent properties)
>
>
> The issue doesnt go away, though. Parent/child still happily
> completes.
>
>
>
>
> ....HELP!!...
>
>
> -Blair.
>

Relevant Pages

  • Re: Pass variables from parent DTS to child DTS package...
    ... Pass variables from parent DTS to child DTS package... ... I have a parent DTS that calls a child DTS through ActiveX scripts. ...
    (microsoft.public.sqlserver.dts)
  • Re: How to correctly by pass "protected"
    ... > declaration to match the parent and everything works. ... different package) then the only way that code in Child can call protected ... explaining what's broken and getting them to fix it. ...
    (comp.lang.java.programmer)
  • Re: Can a child access private types of its parent?
    ... in the Parent's type P from Child (in function Get, ... 05 package Parent is ...
    (comp.lang.ada)
  • Child Package Fails when not all child steps are run.
    ... We have two diferent packages (parent and child) to load text files. ... The child package has a condition node that decides if all steps should ...
    (microsoft.public.sqlserver.dts)
  • Unix Programming FAQ (v1.37)
    ... Why use _exit rather than exit in the child branch of a fork? ... Why doesn't my process get SIGHUP when its parent dies? ... How do I create a named pipe? ... How do I compare strings using regular expressions? ...
    (comp.unix.programmer)
Loading