SSIS错误：0xC002F210“查询过于复杂。“可能的失败原因：查询问题，“ResultSet”属性设置不正确，参数设置不正确或连接未正确建立。 [英] SSIS Error: 0xC002F210" Query is too complex.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

问题描述

错误：0xC002F210在提取数据，执行SQL任务：执行查询"SELECT 1 AS EXCEL_FILE_ID，44 A​​S [EXCEL_SHEET_ID]，..."失败并出现以下错误："查询过于复杂。"。可能的失败原因：查询问题，
" ResultSet"属性设置不正确，参数设置不正确或连接未正确建立。

Error: 0xC002F210 at Extract Data, Execute SQL Task: Executing the query "SELECT 1 AS EXCEL_FILE_ID ,44 AS [EXCEL_SHEET_ID],..." failed with the following error: "Query is too complex.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

尝试在执行SQL任务中运行以下SQL：

Trying to run following SQL in Execute SQL Task:

SELECT 1 AS ID， file_id，* FROM table1

SELECT 1 AS ID ,file_id, * FROM table1

UNION ALL

UNION ALL

SELECT 2  AS ID，file_id，* FROM table 2

SELECT 2  AS ID ,file_id , * FROM table 2

UNION ALL 

UNION ALL 

.......

........

SELECT 100  AS ID，file_id，* FROM表100

SELECT 100  AS ID ,file_id , * FROM table 100

sql语句的总长度为5501个字符

total length of sql statement is 5501 characters

推荐答案

我会将查询转换为一个过程然后从执行SQL任务中调用它

I would turn the query into a procedure and then call it from Execute SQL task

首先给我更好的调试和测试程序选项并确保它在以前正常工作从SSIS执行SQL任务调用它。

Just gives me better options for debugging and testing procedure first and ensure it works correctly before invoking it from SSIS Execute SQL Task.

这篇关于SSIS错误：0xC002F210“查询过于复杂。“可能的失败原因：查询问题，“ResultSet”属性设置不正确，参数设置不正确或连接未正确建立。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！