execute stored procedure in DTS task

• yiminghu_carol

  SSC Rookie

  Points: 37

  More actions

  February 22, 2002 at 8:10 am

  #105064

  I want to execute a stored procedure in DTS task. This stored procedure has one input parameter and one out parameter.

  Following is the simplified sample:

  create procedure spInOutputTest

  @InTest int,

  @OutTest int output

  as

  set @OutTest = @InTest + 1

  And I type following statements in DTS 'Execute SQL Task'

  declare @OutTest int

  EXEC spInOutputTest ?, @OutTest OUTPUT

  SELECT @OutTest AS OutTest

  I was trying to click parameter button to map the input parameter and output parameter, but there is an error dialogue popping up stating there is a sytax error or access violation.

  Can anybody here help with this problem? Thanks in advance.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  February 22, 2002 at 8:27 am

  #424326

  It will not let you mix this way.

  Try create procedure spInOutputTest

  @InTest int

  as

  SELECT @InTest + 1

  Then just do

  EXEC spInOutputTest ?

  this will work.

  Sorry I could not find the reason.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)