Post reply

Passing Output Parameter From Stored Proc to DTS Package

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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply