Post reply

SSIS package: calling stored procedure with in/out parameter (rowset as outparameter)

  • June 11, 2008 at 7:35 am

    #183333

    Hi,

    can anyone help me with an example of a stored procedure that returns a rowset that I will catch in a varable of datatype object. I have managed to execute the syntax for a stored procedure in an Execute SQL Task but the full result set that I get back in empty. But if I write the select statement in the Execute SQL Task I get the result set back and put it in the variable of type Object.

    Anyone that have done something like that and actually got it to work??

    Thanks a lot!

    /Yvonne

  • June 11, 2008 at 8:12 am

    #827271

    It should be exactly the same as executing a select statement from an Execute SQL Task. Set the ResultSet = Full Result Set and in the Result Set tab set the Result Name = 0 and assign the variable.

  • June 12, 2008 at 7:04 am

    #827807

    Make sure you have SET NOCOUNT ON at the top of your procedure if it does more than one operation. SSIS sees the rowcount notifications and data sets and returns the first one - which will contain nothing.

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

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