Determine if Package failed or success

[awolff02]

Hi. I am confused.

I have an ActiveX task (TaskA) that does stuff.

At the end of the script I set the variable:

Main = DTSTaskExecResult_Success

-or-

Main = DTSTaskExecResult_Failure

What code do I need in the parent package to determine whether the TaskA was Success or Failure?

I guess I am also confused as to the difference between a Task and a Step? Can a task have multiple steps? or vice versa?

TIA-

Alex

 

[mkal]

I believe what your talking about is called "Precedence Constraints". For more information you can read about them in "Books Online" (BOL) which is the help file for SQL Server. Search for "DTS Package Workflow" and "Using ActiveX Scripts in a DTS Workflow" which should give you a basic understanding of how this works.