hi,
I have created a package say "Parent" and from this package I am calling another package say "Child".
Now if my child package is failing due to some reason then I want to stop the processing of Parent package also.
As the parent package never come to know about the failure status of the child package, is there any way to stop processing of Parent.
May be Parent package can have two path from child package, one in case of success and another for failure.
I tried with this but it never follows the failure path.

Please help me out.
You can mail me to [email protected]

use and activex scripts for failure results or use the workfloe on failure to stop process


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

Function Main()
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.GetFile("<path to your file or server>")

If objFile.Size >0 Then
main = DTSTaskExecResult_success
else
main = DTSTaskExecResult_failure
end if
End Function


Jaime E. Maccou

In parent package, right click child package task goto WorkFlow -> WorkFlow Properties -> Options tab uncheck all the check boxes from the "Execution" frame and try. Please recheck the Workflow precedence also.

Thanks a lot for this answer, i will try doing this.
Currently I have written two AST task. one in child package and on ein the parent package. I m writing flag status to the file from the child package, and reading it from parent package, thats it. this is a workaround.

I have tried doing WorkFlow -> WorkFlow Properties -> Options tab uncheck all the check boxes from the "Execution" frame, but still it wont follow the failure path.

Did you try creating the activex scripts and adding it after your task

Jaime E. Maccou

Yes. That is what I was doing,
if the task is failing set
Main = DTSTaskExecResult_Failure
otherwise Success.
But parent package always follow success path.