0

I have an Execute SQL task that returns "Full result set". Despite that, the task fails. Please how can I fix it ?

[SQL query execution task] Error: The binding name of the results must be zero for the complete result set and the XML results.

2

Click on ResultSet in the Execute SQL Task, click Add. In the 'ResultSetName' column, enter the exact name of the columnname that you are retrieving or simply give it 0. In the 'variablename', select the variable you created to map the data returned.

Not the answer you're looking for? Browse other questions tagged or ask your own question.