DTS conditional workflow

[marksisson]

My goal is to have Task1 always occur before Task2 but in addition, I want Task1 to only run when certain conditions are true. The conditional part is fine: I've got a global var that I interogate in Task1's workflow activex script as such:

if DTSGlobalVariables("DoBCP&quot.Value then
Main = DTSStepScriptResult_ExecuteTask
else
Main = DTSStepScriptResult_DontExecuteTask
end if


But when Task1 doesn't execute, Task2 doesn't either. I set Task2's workflow precedence to "Completion" but it won't run if Task1 didn't execute.

What's the best workflow answer to this??
thanks

 

[foxdev]

I'm not clear (probably not enough coffee): do you want Task2 to always run, regardless of whether Task1 runs or not? Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com

 

[marksisson]

Hi Robert - yes, I would like Task2 to always run regardless if Task1 runs or not. I've dreamt up some fancy ways to get around this but I'm hoping that is a simple DTS workflow issue (maybe not).

 

[foxdev]

After going through various scenarios, I see your predicament. The only thing I can think of is:

TaskA is an ActiveX task that contains the logic of whether Task1 should be run;
if Task1 should be run, it invokes it;
in either case it runs Task2.

Other scenarios I thought of involved creating separate DTS jobs for Task1 and Task2, which are no cleaner. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com