Can anyone explain what PrecedenceBasis Property is? and please, explain it like I'm 4 yrs old. Thanks.

Cheers,

GMG

A workflow constraint is basically a test, and when true the constraint is
followed.

So an On Success workflow constraint is testing for the step execution
result (ExecutionResult property) to equal the success value
(DTSStepExecResult_Success constant). Conversely when using an On Failure
constraint the execution result needs to equal failure
(DTSStepExecResult_Failure constant). So on the constraint we store the
execpcted value for testing, the Value property.

Since the ExecutionResult property only has two possible values, how do you
do a On Completion? The way it is done is by no longer testing the result,
instead you test the status (ExecutionStatus Property). So an On Failure is
a test of the execution status where it needs to equal completed
(DTSStepExecStat_Completed Constant).

As described above you now need two pieces of information for your test,
first you need to know which property you are testing, and secondly what is
the value to test for. The precedence basis tells us which property to test,
either the execution status or result, and the Value described above is the
test.

Make sense now?

Incidentally, out of the box you get three workflow constraints, but in
theory there are 6. There are the two possible values for the execution
result (See DTSStepExecResult), and the four possible values for the
execution status (See DTSStepExecStatus).


--
Darren Green
http://www.sqldts.com


"Casualinfoguy" <anonymous (AT) discussions (DOT) microsoft.com> wrote