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

Question

I have an SSIS execute SQL task. It returns a Full result set (i.e. a table). Howevr I get the following error when I execute the package. I have correctly give a name for the returned result set.

[Execute SQL Task] Error: The result binding name must be set to zero for full result set and XML results.

How to solve this?

Answer 1

There's nothing tricky in here. Just name your variable 0 - that will do the trick. Cheers.

Answer 2

Respecting to @makciook' s answer, I want to add a picture of how you can do that since it took me sometime to figure out after seeing his/her answer. All you need is to double click the "Execute SQL Task", go to the "Result Set" on the left and set the Result Name is 0 where the Variable Name is the object type of variable you want to use.

Answer 3

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