Database and BI blog

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

This error “The result binding name must be set to zero for full result set and XML results” usually occurs if you are using Execute SQL Task and assign the result set to a variable.

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

The easiest way to fix this is instead of using names for your Result Name using ordinal positions like 0,1,…

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

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

Read More:
http://msdn.microsoft.com/en-us/library/cc280492.aspx

Follow

Get every new post delivered to your Inbox

Join other followers