Exec different Scripts based on result of stored procedure

• Fallen Angel

  Ten Centuries

  Points: 1128

  More actions

  November 1, 2004 at 10:18 am

  #61357

  In my DTS Package, one of the step is Exec SQL task and that is what I put in:

  Declare @result int

  Exec @result = uspStoredprocedure

  What I want is

  If @result = 0

      exec Active X script 1

  If @result = 1

      exec Active X script 2

  But I don't know how to do this in the EXEC SQL TASK.

  Does anyone have any idea?

  Thanks a lot.

   

   

   

   

   

   

   

• Jonathan Stokes

  SSCrazy Eights

  Points: 9861

  More actions

  November 2, 2004 at 7:53 am

  #528620

  Look up global variables in dts packages.

  You can populate a global variable in your sql script and use it anywhere in your package. In your case, the activex script.

  ---

  ------------------------------
  The Users are always right - when I'm not wrong!