SSIS 中的错误错误 - [执行 SQL 任务] 错误:为 ResultSetType 返回的结果绑定数量无效:“ResultSetType_Rowset" [英] Wrong error in SSIS - [Execute SQL Task] Error: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_Rowset"

问题描述

我有一个执行 SQL 任务，它只返回一行和一列 - 一个数字.我将结果集设置为单行.尽管如此，任务还是失败了.为什么 ?我该如何解决?

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 ?

[Execute SQL Task] Error: There is an invalid number of result bindings returned for the 
ResultSetType: "ResultSetType_Rowset".

推荐答案

可能是您没有正确配置结果集参数.要配置它，请单击执行 SQL 任务"中的结果集"，然后单击添加".在ResultSetName"列中，输入您要检索的列名的确切名称或简单地将其设为 0.在变量名"中，选择您创建的变量以映射返回的数据.

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.

这篇关于SSIS 中的错误错误 - [执行 SQL 任务] 错误:为 ResultSetType 返回的结果绑定数量无效:“ResultSetType_Rowset"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！