Post reply

RowSet Problem

  • July 28, 2008 at 10:37 am

    #154569

    hello to every one

    I am trying to use a Exe Sql Task (EST) to select rows from a certain table and then using a precedence constraint to send it to the control flow for the processing. Here is how i did it

    i made a variable.

    Used a select statement in it to retrieve the desired result.

    Define it in the EST

    No parameters or expressions defined but

    it is giving me error

    [Execute SQL Task] Error: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_Rowset".

    what to do?

    thanks

  • July 28, 2008 at 2:50 pm

    #849459

    what have you specified for the result set?

    tom

    Life: it twists and turns like a twisty turny thing

  • July 28, 2008 at 2:59 pm

    #849470

    the column name that i want to retrieve and the variable name used

  • July 28, 2008 at 3:08 pm

    #849475

    i can't quite remember (i don't have ssis on this machine) but for result set i think you can choose to have either none, single row, full rowset or xml.

    if you have select full rowset, then you can only populate one variable (of type object) with an ADO recordset. You then consume that with something like a foreach loop.

    perhaps you might want to use a single row, where you can map columns from the recordset to individual variables.

    does this sound right, or have i got the wrong idea about your problem?

    tom

    Life: it twists and turns like a twisty turny thing

  • July 28, 2008 at 3:10 pm

    #849480

    i did choose the single row

    but it wont work

  • July 28, 2008 at 3:19 pm

    #849486

    is your sql statement calling a stored proc with an output parameter?

    Life: it twists and turns like a twisty turny thing

  • July 28, 2008 at 3:24 pm

    #849491

    NO actually not i am using the simple sql statement with one input and one returning value

  • July 28, 2008 at 3:27 pm

    #849494

    could you post the code here?

    Life: it twists and turns like a twisty turny thing

  • July 28, 2008 at 3:31 pm

    #849496

    select pk_val from pkid where pk_name='Formid'

  • July 29, 2008 at 2:00 am

    #849599

    and you have set the resultset to single row. in the result set section, you should have one entry, with the result name set to "0" and the variable name set to the variable in which you want the value of PK_val to be stored.

    Is this correct?

    Life: it twists and turns like a twisty turny thing

Viewing 10 posts - 1 through 9 (of 9 total)

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