DTS SQL task and return values

• jsqldba

  SSChampion

  Points: 11257

  More actions

  November 6, 2002 at 6:49 am

  #159064

  I have a DTS package which performs a SQL task. The SQL task is the execution of a stored produre, which return 0 on success, -1 on failure. Yet the DTS task does not detect this, and succeeds for any return value.

  How do you communicate the return code from a stored proc to the DTS task? Can you?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736458

  More actions

  November 6, 2002 at 10:35 am

  #440512

  raiserror

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

• jfb

  SSCrazy

  Points: 2469

  More actions

  November 7, 2002 at 4:02 pm

  #440776

  In the workflow properties using ActiveXscript you can get the value from the store procedure using Global Variables and check if is 0 then Main = DTSTaskExecResult_Success, or -1 then Main = DTSTaskExecResult_Failure

  Johnny...