sql server dts: How to execute tasks base on a flag -- sql server dts

RE: How to execute tasks base on a flag

bharat jariwala
1/19/2006 9:00:02 PM

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

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

[quoted text, click to view]

Re: How to execute tasks base on a flag

Allan Mitchell
1/21/2006 3:11:07 AM

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

[quoted text, click to view]

Re: How to execute tasks base on a flag

Joann
1/21/2006 10:20:37 AM

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

Joann

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.