Post reply

Execute SQL Task

  • May 31, 2005 at 5:00 pm

    #60141

    Hi ,

     

    I have written a stored procedure that has two parameters.An input parameter and an output paramter.I am trying to execute the stored procedure using the execute sql task.

    exec proc ?,?

    I am using two global variables one for input paramter and the other for

    the output parameter.

    Though i am able to map the input paramter tab ,i am not able map the

    output parameter.

    Could you please let me know how to go about in this regard

    Thanks

    Suresh

  • May 31, 2005 at 6:13 pm

    #562059

    You'll need to specify the OUTPUT keyword on the EXEC PROC command. eg: EXEC PROC ?, ? OUTPUT

    Also, have you specified the parameter as an output parameter in your stored procedure?

    I've had better luck just doing a SELECT @MyParameter at the end of the proc. This returns the value as a resultset that is picked up in the output parameters dialog.

     

    --------------------
    Colt 45 - the original point and click interface

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

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