Can an ActiveX Script (DTS) return complete instead of success or failure?

Question

An ActiveX Script in a DTS package can return DTSTaskExecResult_Success or DTSTaskExecResult_Failure. Is there a way to indicate that it is not a success without failing the entire package? We'd like it to keep going, but in a different direction. The options for a path are Success, Failure, and Completion, but it appears the only return values for the ActiveX Script are Failure and Success. 'DTSTaskExecResult_Completion' isn't right. What is?

(The solution we're probably going to pursue is modifying this to SSIS, but I wanted to know if it was possible in DTS.)

Answer 1

As far as I know, when using the ActiveX DTS Component, your options are limited to Success/Failure. :(

-Shaun

Answer 2

Try setting the DTSTaskExecResult_Retry return value, it tells you that it failed, but doesn't failout completely?

Edit: sorry it is : DTSTaskExecResult_RetryStep

---

FYI: ActiveScriptTask objects have full access to the GlobalVariables collection, which provides a way to share information across tasks.