RowSet Problem

  • 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

  • what have you specified for the result set?

    tom

    Life: it twists and turns like a twisty turny thing

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

  • 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

  • i did choose the single row

    but it wont work

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

    Life: it twists and turns like a twisty turny thing

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

  • could you post the code here?

    Life: it twists and turns like a twisty turny thing

  • select pk_val from pkid where pk_name='Formid'

  • 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