Error : The result binding name must be set to zero for full result set and XML results

Question

I have only a single row that is being returned from a sql query(count(*)), but upon execution of the package, it shows me the above error and package is failing.

I have the result type to "single row", and have mapped the output of the query(select count(*) as 'result' from abc.tbl_nm) to a variable of type Int32.

Mcmichael

Answer 1

When mapping your 'Result Set', set your 'Result Name' to '0' and 'Variable Name' to the variable you are using.

Cicisbeo

That was not the least bit obvious. Thanks for clearing that up. – Donadonadee

Bit more info technet.microsoft.com/en-us/library/… – Spatter