Passing Output Parameter From Stored Proc to DTS Package

• Landon

  SSC Eights!

  Points: 840

  More actions

  January 31, 2005 at 4:27 pm

  #163526

  I'm trying to pass a output parameter from a Stored Proc to an "Excute SQL Task" or "Active X Task."  I'm having trouble reading in the output parameter to either of these tasks.  Any suggestions on how to get this to work, or an easy way to do this?

• Jamie Thomson

  SSChampion

  Points: 11805

  More actions

  February 2, 2005 at 2:13 am

  #540101

  In the ExecuteSQL task the '?' symbol is a placeholder for parameters. You can map parameters to these placeholders using the ExecuteSQL Task Editor dialog. Don't forget that if it is an output parameter to use the word OUTPUT as you would in any call to a stored proc with an output parameter.

  Judging by your use of an ActiveX script task you are obviously using DTS2000 in which case this is the wrong forum on which to place this question. Try the regular Data Warehousing-->DTS forum!

   

  Jamie Thomson
  http://sqlblog.com/blogs/jamie_thomson