Hi

I wonder if anyone could just confirm that I've set up my package
logging OK with a DTS package system I've set up. This is what happens:


PACKAGE 1
PACKAGE 2
PACKAGE 3


Now, I know that normally, for a failure on a child package to cause an
'upward cascade' failure into the master package, the 'Fail Package On
First Error' needs to be checked in the Logging options for the Child
package, but NOT for the Master package.

However, in the above, I want a failure in Package 3 to cause a failure
in Package 1. I've done a few tests, and by setting 'Fail Package On
First Error' in BOTH packages 2 and 3, this seems to grind all 3
packages to a halt when number 3 fails, which is what I want. I was
just wondering if anyone could confirm that this is the way I'm
supposed to be doing it? I know this can be a notoriously tricky thing
to get right, and with Package 2 being both a master and child package,
I'd feel better if someone with a bit more experience could put my mind
at rest!

Thanks in advance