In my DTS pkg, I have an ActiveX script that has a condition:

if <condition> = True Then
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_Failure
End If

On the failure condition, I set a workflow (red) connected to a task for
sending me (xp_sendmail) email. I ran this pkg as job. Everything is
working as it is supposed to.
The only issue is on failure condition, the job shows it is failed (red
color). In actualty, it is the condition that failed ..not the job! Is
there it can be avoid i.e. if the condition fails, I need the job to be
shown successful. Any help would be appreciated.





*** Sent via Developersdex http://www.developersdex.com ***

You have code which makes the step fail if your condition is not True.
If you dont want it to fail, then you may very well have to change the
codition statement to suit your needs.

Hi "however I should call you?"

"Test Test" <farooqhs_2000 (AT) yahoo (DOT) com> schrieb im Newsbeitrag
news:uk7mMhyTFHA.3308 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
when one step fails the package is reported as failed.
If you don't wan't the condition be reported as failure, just don't raise
the error, but change the control flow instead.
In your example you can dynamicly disable the next step for success or
"failure" and enable the other, so that only one flow continues - both
depends on succes of the condition step.

Helge

Helge,

Thanks for your help. Can you plz. give an example of what you said.

In your example you can dynamicly disable the next step for success or
"failure" and enable the other, so that only one flow continues - both
depends on succes of the condition step.

Thank you!


*** Sent via Developersdex http://www.developersdex.com ***

HI,

"Test Test" <farooqhs_2000 (AT) yahoo (DOT) com> schrieb im Newsbeitrag
news:%23QL6iZ%23TFHA.612 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
you can disable each step with ActiveX or the dynamic properties task during
execution of package.
look at the following page for explanation and a sample
http://www.sqldts.com/default.aspx?218
Because you don't want to merge the flow again, you only have to adapt the
code at the beginning of page 2 for disabling/enabling the next steps and
don't need to manipulate precedense constraints.

HTH
Helge

Thanks a lot, Helge!!!



*** Sent via Developersdex http://www.developersdex.com ***