Hi...
My first taks is an ActiveX. Inside it, I have a test, and depending on the
result I want to cancel the rest of the package and terminate the execution.
How to do it?
Thanks...

If condition true
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_Failure
End If

"Eduardo Greco" wrote:

Put this in you code to make the task fail


if ( condition ???????? )then
Main = DTSStepScriptResult_DontExecuteTask
else
Main = DTSStepScriptResult_ExecuteTask
end if

And in the package properties there is a option to make fail the
package on any error, check it ...

or you can set he properties of this to fail the package when it fail
Set oPkg = DTSGlobalVariables.Parent
oPkg.Steps("DTSStep_DTSExecuteSQLTask_?????????"). FailPackageOnError =
True

In message <ca36fb3.0408120538.3fc372b (AT) posting (DOT) google.com>, mtl_jf
<jf_lanouette (AT) hotmail (DOT) com> writes

That codes needs to go in the workflow script not the task itself.
Workflow scripts can be found by right-clicking any task, Workflow -
Properties - Options, check the box and click the button for script.

Another example of using scripts to halt, but not fail a a package-

How can I check if a file exists?
(http://www.sqldts.com/default.aspx?211)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org