I have a job that has a number of steps of which the last two are to be
executed only if certain conditions are met. In the workflow
properties/activex script for these last two steps I have the following:
IF DTSGlobalVariables("SkipEndTasks").Value then
Main = DTSStepScriptResult_DontExecuteTask
else
Main=DTSStepScriptResult_ExecuteTask
end if

This works to a degree because the two steps aren't executed which I want
however when the package is executed through vb I step throught the steps to
determine if there's an error, i.e. DTSStepExecResult_Failure. Unfortunately
when the last two steps are not run due to the above code the step returns
failure. I don't know why it returns failure and am wondering what I'm doing
wrong. Thanks

It is probably because the step did not execute so is treated as though it
failed. ExecutionResult = 1

What you could do is check the ExecutionStatus for a value of 3 and then
return a success.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote