Search code examples
sql-serversql-server-2005activexdts

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

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.)

Solution

  • 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.