Re: DTSStepExecResult, DTSStepExecStatus, and execute package task

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 11/16/04 

Date: Tue, 16 Nov 2004 17:50:16 -0000

An execute package task will only fail through a child error if the *child*
has fail on first error set to true.

The exec package task worked, it executed the child package, so is a child
failure a failure of the parent task? How does a child execution failure
compare to a failure to even load the child? The answer is it can be both
hence you need to set the option for what you want in the child. Not always
ideal, but that is the way it works. 

-- 
Darren Green
http://www.sqldts.com
"Kevin Lloyd" <klloydsqldba@yahoo.com> wrote in message
news:6ed68e17.0411160901.4e6f46d7@posting.google.com...
> I have a package with several steps (execute package tasks) which
> execute other DTS packages.  Attached to each step, I have an ActiveX
> workflow script to check the exection of the previous step (the
> ultimate purpose will be to act as a failure step and send mail).
> This script, as expected, runs prior to the execution of the execute
> package task.
>
> However, the DTSStepExecResult value is not returning correctly based
> on the execution of the previous step (the execute package task).  The
> previous step fails with the error "Column name 'column' was not
> found."  This is an expected error from the package.  The
> DTSStepExecResult for the previous step returns 0
> (DTSStepExecResult_Success) and 4 (DTSStepExecStat_Completed) for
> status, so I know it has executed.  It should be returning
> DTSStepExecResult_Failure.
>
> Both execute package steps (tasks) are set to execute on main thread
> and fail package on error is false.  I have also tried the setting
> off, and it executes with the same issue.  The ActiveX workflow for
> the step after the failing step is as follows (normally an 'if'
> statement would check and then DTSStepScriptResult would be set
> accordingly):
>
> Function Main()
>
> msgBox DTSGlobalVariables.Parent.Steps("ExtractOrders").ExecutionResult
> msgBox DTSGlobalVariables.Parent.Steps("ExtractOrders").ExecutionStatus
>
> ' check all steps just to make sure
> for each step in DTSGlobalVariables.Parent.Steps
> msgbox step.Name & ":        " & step.ExecutionResult
> next
>
> Main = DTSStepScriptResult_DontExecuteTask
> End Function
>
> If you have seen this or know what might be incorrect to fix it,
> please let me know.  Standard DTS package and not executing through VB
> or VB.NET.
>
> Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> Thanks, Kevin

Relevant Pages