I have an ActiveX step that validates a global variable, when the validation
is false, I do a

main = DTSTaskExecResult_Failure

the task exists nicely, but does not report failure so the package moves on.
How do I fail this properly so the package halts execution ?

What about setting the package level property "Fail on First Error" to true
in the package properties?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jeff Block" <jblock@REMOVETHECAPSANDINVALIDfirstlook.biz.invalid> wrote in
message news:e9iQTHwAEHA.356@TK2MSFTNGP10.phx.gbl...
[quoted text, click to view]