I am trying to get an ActiveX script task to fail. Using the script below
it always goes to the on-success leg. Can someone tell me how to fail this
task so it goes to the on-failure leg/.



'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************

Function Main()

if DTSGlobalVariables("RUNFLAG").Value <> "Y" then
Main = DTSTaskExecResult_Failure
else
Main = DTSTaskExecResult_Failure
end if
Main = 0
End Function

Hello news.microsoft.com,

The last value you are assigning to Main is 0. This is what is returned.

DTSTaskExecResult_Failure 1 Task execution failed.
DTSTaskExecResult_RetryStep 2 Task execution is to be repeated.
DTSTaskExecResult_Success 0 Task execution succeeded


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com