Returning False from DTS Package Task

Question

Returning False from DTS Package Task

Simon-220850

SSCrazy

Points: 2789
More actions
September 26, 2005 at 5:15 am

#68490

Hi
I have a DTS Package A which itself calls another DTS package B using the DTS package task. There is some control flow which after running this DTS Package B conditionally should run Active X script A if the it is successful or Active X Script B if unsuccessful.
However Active X script A gets called whether the execution of DTS Package B was successful or not.
Has anybody else had problems with this type of conditional branching after a DTS Package Task
Cheers

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

Try setting in the child package properties logging Tab: Fail Package on First Error. Otherwise even if the task fails, the package does not - and your calling package still assumes the called package succeeded.

If that doesn't work, see one of these threads:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=146755

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=15947

Greg

Simon-220850 SSCrazy Points: 2789 More actions · Answer 2

Hi Greg

Great, Almost there, but I would also like package B to run through and finish its own conditional branching when any of the tasks internal to it fail. I have a feeling the answer on this one is going to be more of a definite no .

Cheers for the links aswell. Getting child Global variables was something else I was looking into to

Simon

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

You might be stuck with something kludgy like having the child package update an error table when a task fails and having the parent package query the table on return from the child to determine if an error occured. I haven't dealt with that myself, so good luck!

Greg

Bill Geake Ten Centuries Points: 1352 More actions · Answer 4

This has been a problem for me too. I have loads of packages which call others, and currently they run on a hit and hope basis.

I think a solution is to call the child package with an ActiveX script (though I haven't progressed further so don't know how, just that it can be done). I'm told that this allows the parent package access to all the global variables of the child, so you should be able to do almost any flow control you need to.

HTH

Bill.

mike gercevich SSCrazy Points: 2961 More actions · Answer 5

See this post of mine on a simular topic for an example:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=221076#bm221486

-Mike Gercevich