I have written an activex script for a transform data task.
If i get a null value for any field during the transformation i want the task to fail and execute the task specifed with the on failure precedence.
what value do i have to assign to MAIN in the activex script for the on failure task to be executed.

I tried MAIN = DTSTransformStat_AbortPump and MAIN = DTSTransformStat_Error. but it didn't work.

Any suggestions ?