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 ?
我有一个执行SQL任务,它只返回一行一列 - 一个数字。我将结果集设置为单行。尽管如此,任务失败了。为什么?我如何解决它 ?
[Execute SQL Task] Error: There is an invalid number of result bindings returned for the
ResultSetType: "ResultSetType_Rowset".
2 个解决方案
#1
4
Probably, you haven't configured your resultset parametrs correctly. To configure it, 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.
您可能没有正确配置结果集参数。要配置它,请单击“执行SQL任务”中的“ResultSet”,然后单击“添加”。在“ResultSetName”列中,输入要检索的列名的确切名称,或者只需输入0.在“variablename”中,选择您创建的变量以映射返回的数据。
#2
0
In my case the ResultSet configured to "Full result set" when there were no results being returned. The Stored Procedure I was calling was simply deleting data. So I sat this to "None" and it worked..
在我的情况下,当没有返回结果时,ResultSet配置为“完整结果集”。我调用的存储过程只是删除数据。所以我把它称为“无”,它起作用了..
#1
4
Probably, you haven't configured your resultset parametrs correctly. To configure it, 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.
您可能没有正确配置结果集参数。要配置它,请单击“执行SQL任务”中的“ResultSet”,然后单击“添加”。在“ResultSetName”列中,输入要检索的列名的确切名称,或者只需输入0.在“variablename”中,选择您创建的变量以映射返回的数据。
#2
0
In my case the ResultSet configured to "Full result set" when there were no results being returned. The Stored Procedure I was calling was simply deleting data. So I sat this to "None" and it worked..
在我的情况下,当没有返回结果时,ResultSet配置为“完整结果集”。我调用的存储过程只是删除数据。所以我把它称为“无”,它起作用了..