sql server dts: hi,
If i have five tasks in a package, how am I able to stop the whole process
once error occurs. Do i go to Properties --> Logging --> check on "Fail
Package on first Error"?????
um... what if i have 5 ActiveXTask in a package, do I use Main =
DTSTaskExecResult_Failure to stop the whole process or i need to use "Stop"
to stop the whole process?
Thanks

I look at the sqldts.com to check for errors in the Child Package

For Each oStep In oPkg.Steps
If oStep.ExecutionResult = DTSStepExecResult_Failure Then
Main = DTSTaskExecResult_Failure
End If
Next

What is the code I need to add right after
"If oStep.ExecutionResult = DTSStepExecResult_Failure Then"
in order to stop the whole package?
Thanks
Ed


[quoted text, click to view]