Hello
I need to know how to execute tasks in DTS package base on a flag.
Here is what I am trying to do:

Read the value of the flag... If it the value is true, execute task
A;otherwise, execute task B

Thanks in advance

Joann

You do show using Task constan called , DTSStepScriptResult_ExecuteTask and
DTSStepScriptResult_DontExecuteTask, for example


If(DTSGlobalVariables("Temp_Last_Export_Date_Exist s").Value<> 0 ) then
Main = DTSStepScriptResult_ExecuteTask
Else
Main = DTSStepScriptResult_DontExecuteTask
End if
--
Regards
Bharat Jariwala



"Joann" wrote:

Hello Joann,


Ok So what you can do is this

1. Read the flag. How you read the flag will depend on what the flag is.
2. You then after reading the flag have two tasks on the end of workflow
from the fallg reader task.
3. Based on the flag you set the corresponding step to disabled.

Have a look at this article for an example of doing just this type of thing


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

Allan

This is exactly what I was looking for. Thanks a lot for your help!

Joann