My Execute SQL task is set to use a query that retrieves customer numbers
from a table:

SELECT custID as thecustid FROM custTable WHERE [criteria]

The result set is set to “Full Result Set”. On the Result Set tab, I have
Result Name thecustid mapped to User::g_custID, which is a global-scope
variable of type Object.

When I attempt to run the query, I get this message:

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

What have I done wrong in this setup?

Not to answer my own question, but I figured it out -- changed the ResultName
to 0 and removed any assignment of the output from the select.

"Mike Coffey" wrote:

Hello Mike,

For ExecuteSQL task type configurations have a look at this article


The ExecuteSQL Task
(http://www.sqlis.com/default.aspx?58)


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com