In a DTS I want to transfer data only if some conditions are met.
I get values from a table into global variables using an Execute SQL Task.

Then I use an ActiveX task to check the values. If the conditions are met I
return DTSTaskExecResult_Success, DTSTaskExecResult_Failure otherwise.

Then I connect the rest of the processing to the ActiveX task with a 'On
Success' workflow.

My problem is in case the conditions are not met, the ActiveX task returns
Failure and the step is shown as failed. When I run the DTS as a child of
another DTS, it shows the package failed, which can be confusing.

Is there a way to avoid this? Or maybe there's a more elegant
implementation...

"fleo" <fleo (AT) discussions (DOT) microsoft.com> wrote in message
You can skip the execution of a step without returning Failure. Read
http://www.sqldts.com/?214

Hope this helps
--
Francesco Anti

Thanks.
I had thought about it and didn't want to choose that option, but the
article was really helpful.

I did something a little different. Since I know the ActiveX script step
will always be successfull, I change the precedence constraint value of the
following step I want to take to "On success" and the other one to "On
Failure". Works nicely.

Thanks again

"Francesco Anti" a écrit :