DTS Package Execute reversed success fail

suriv7
suriv7 used Ask the Experts™
on
I currently have a DTS package that calls another DTS package with the  "execute package task"  on success an active x  script runs.  

[EXECUTE DTS] ---precedence---> [EXECUTE active x script]

if I set it to a success precedence:
If the execute dts package fails it will execute the script, if the execute dts package succedes it will execute the script.

if I set it to a failure precedence:
If the execute dts package fails it will not execute the script, if the execute dts package succedes it will not execute the script.

anyone know what would be causing this, the other processes that precceed this pair work correctly.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
[EXECUTE DTS]

It is probably checks the susccess/failure of the package - not the same as the steps inside it. Even if a step fails the package will complete successfully (with a step error but package success).
Try setting the package to fail on first error (I think that's the property) or you can set each step to fail the package on failure.
Top Expert 2004

Commented:
Nigel is correct--this is the way it works.  If you need step "return codes" you would have to code all the steps in one package.

Brett
Da_WeaselSenior Software Analyst

Commented:
Any other ideas on this one?  I tried that, and not matter what I do, it always follows the success path from a Execute Package Task.
Top Expert 2004

Commented:
Da_Weasel, this isn't your question and this question is closed.....You need to open your own question...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial