Child Package Fails when not all child steps are run.

Hi,
SQL 2000 SP4 DTS
Windows 2003 Server sp1

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
be run or only the mandatory ones (the process checks the number of
files to be processed, if it is = 0 the packes exits withou error).
The child package also has a condition node to loop the steps until all
source files have been processed. (Text_Files.Quantity > 0)

When we call the child step manually it works fine no matter if
optional steps where run. (Text_Files.Quantity = Any)

When all child steps run with sucess (at least once) from a Execute
Package Task at the parent both packages work fine. (optional
step.execution Result = 0) (Text_Files.Quantity >= 1)

Whenever we call the child step from a Execute Package Task (from his
parent) and it exits without runing the optional step it fails
(optional step.execution Result = 1). (Text_Files.Quantity = 0)

Can anyone help us?

Thanks a lot.

.

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: Child Package Wont Fail Parent
    ... No matter the result of the child package the package task in the parent will ... > child completes anyway, parent doesnt fail. ...
    (microsoft.public.sqlserver.dts)
  • Re: 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 also has a condition node to loop the steps until ...
    (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: Protected Distribution Points
    ... If your clients are assigned to the child primary site then my take is you ... Distribution Points can be members of a DFS cluster, ... > want to use DFS for package distribution and new machine builds. ...
    (microsoft.public.sms.misc)