Get completion task to execute if any branch succeeds

• ariengel

  SSC Veteran

  Points: 247

  More actions

  June 9, 2004 at 10:19 am

  #59836

  I have a DTS package that parses a text file and then archives it. Based on what type of file it is, it will follow 1 of the 3 branches in the package.

  I would like the final step (archiving) to occur if ANY of these branches succeed. The only way I have been able to get this to work is by having a seperate archiving task for each branch.

  When I put just one archive task at the end of the workflow, it wants ALL of the branches to succeed. Can someone recommend a better way to do this so I don't have to maintain duplicate Archive modules?

  Thanks in advance.

• philcart

  SSC-Forever

  Points: 47794

  More actions

  June 9, 2004 at 4:17 pm

  #509750

  The only real way to get this to work is by using workflow scripts.

  Take a look at this article,

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

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