July 28, 2008 at 10:37 am
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
July 28, 2008 at 2:59 pm
the column name that i want to retrieve and the variable name used
July 28, 2008 at 3:08 pm
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
July 28, 2008 at 3:10 pm
i did choose the single row
but it wont work
July 28, 2008 at 3:19 pm
July 28, 2008 at 3:24 pm
NO actually not i am using the simple sql statement with one input and one returning value
July 28, 2008 at 3:27 pm
July 28, 2008 at 3:31 pm
select pk_val from pkid where pk_name='Formid'
July 29, 2008 at 2:00 am
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply