Workflow Problem with Execute Package Task

• Syed Asim Rizvi

  Ten Centuries

  Points: 1162

  More actions

  November 17, 2006 at 3:43 pm

  #72190

  I have a Master Package in SQL 2000, where I call serveral Child Packages using Execute Package Tasks. Each child have both Success and Failure Workflows. But workflow doesn't seem to work with Execute Package Tasks.

  I've noticed when one of the packages fails, the next package in line still

  executes despite the failure and never go to Failure path.

  I tried with and without setting "Fail Task on First Error" on both Master and Child Packages as well as on indivisual Steps. But nothing seems to work.

  What is going on here, please help.

  Appreciated!

• November 20, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  November 20, 2006 at 3:59 pm

  #673098

  Try having the child package join the parent package's transaction.  Then, if the child package fails, the parent package will also fail. 

  1. Right-click on the Execute Package task in the parent package & select Workflow properties.

  2. On the options tab, check 'Join transaction if present' and OK.

  Greg

  Greg

• Neil Fursey

  SSC Rookie

  Points: 37

  More actions

  December 7, 2006 at 3:16 am

  #676530

  I've tried this and it makes no difference.  Did this work for you Greg or is there another solution?

  Neil.

• Neil Fursey

  SSC Rookie

  Points: 37

  More actions

  December 7, 2006 at 3:49 am

  #676534

  This setting doesn't appear to have any effect on workflow. 

  I found that the failure from the child package is bubbled up to the parent if the child package has the 'Fail package on first error' flag checked.

  This means you can't manually handle any failures within the child package.