DTS :: Logical OR implementation

• vinesh

  Newbie

  Points: 2

  More actions

  October 29, 2007 at 4:41 am

  #376541

  Hello there,

  while working on a DTS package, i reached a situation where i need to implement logical OR instead of logical AND. how can i get that?

  well, for instance assume a package with 4 activeX scripts

  -------ON SUCCESS----> script2------>

  script1

  -----ONCOMPELTE-----> script4

  ------ON FAIL---------> script3------>

  package will start from script1.

  On Success, i need to execute script2

  On Fail, i need to execute script3

  regardless of result, after completion of either script2 or script3 i need to execute script4.

  how can i achieve this?

  Many thanks and hope someone can offer something for this.

  ---

  Kindest Regards,

  Vinesh K Velaga

• philcart

  SSC-Forever

  Points: 47797

  More actions

  October 29, 2007 at 5:26 am

  #746175

  Check http://www.sqldts.com, I'm sure they have an example there.

  --------------------
  Colt 45 - the original point and click interface

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  October 29, 2007 at 8:59 am

  #746280

  http://WWW.SQLDTS.COM does have an example that I've used in a couple of packages:

  http://www.sqldts.com/218.aspx

  Greg

  Greg

• vinesh

  Newbie

  Points: 2

  More actions

  October 29, 2007 at 9:25 am

  #746287

  philcart / Greg Charles

  Thanks for your quick responses.

  i got that article

  ---

  Kindest Regards,

  Vinesh K Velaga