Search code examples
ssisssis-2008

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

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.

Solution

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