Wrong error in SSIS - [Execute SQL Task] Error: There is an invalid number of result bindings returned for the ResultSetType: “ResultSetType_Rowset” I have an Execute SQL task which gives returns only one row with one column - a number. I set my result set to single row. Despite that, the task fails. Why ? How do I fix it ?

[Execute SQL Task] Error: There is an invalid number of result bindings returned for the 
ResultSetType: "ResultSetType_Rowset".
In the Execute SQL Task, when the Result Set property is set to any value except None, the result set(s) must be mapped on the Result Set page, as shown below.

The "Result Name" column is a bit misleading; what's actually required is a zero-based number.



Unfortunately, none of these requirements are validated at design-time, so the editor will happily let you click OK without entering all the necessary information.