postgresql - SQL 查询错误 : The query failed to parse. HResult 异常:0x80040E14

Question

我正在使用 SSIS 创建到 postgresql 服务器数据库的数据流任务。

我收到 SQL 查询错误:

The query failed to parse. Exception from HResult: 0x80040E14

请看下面的截图:

https://ibb.co/7KcBnMG

https://ibb.co/zR093SQ

正在尝试的查询是:

INSERT INTO public.controlflow_example(rollnumber) VALUES (1)

连接本身没问题。 schema是public的，table确实是controlflow_example的拼写，column是整型，名字叫rollnumber

甚至使用

SELECT * 
FROM public.controlflow_example 

作为一个更简单的查询给出了同样的错误。

如果我尝试运行该包，它会失败并出现以下错误:

SSIS package "C:\Users\AJ\Documents\Visual Studio 2017\Projects\control_flow_example\control_flow_example\Package.dtsx" starting. Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "INSERT INTO public.controlflow_example(rollnumber)..." failed with the following error: "Exception from HRESULT: 0x80040E14". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Task failed: Execute SQL Task Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package "C:\Users\AJ\Documents\Visual Studio 2017\Projects\control_flow_example\control_flow_example\Package.dtsx" finished: Failure. The program '[15288] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).

有什么建议吗？

我已经在这里和其他地方搜索过类似的问题，但找不到解决方案。

谢谢。

Answer 1

也许您应该更改函数名称并使用 private 它可以正常工作。

INSERT INTO public.controlflow_example column name VALUES ('1');