sql-server - SSIS 包手动运行但不是从 SQL 作业运行

Question

当 SSIS 包(部署在文件系统中)从 SQL 作业执行时，我收到一系列错误，但如果手动执行，相同的包工作正常。

第一个错误:

Directing the row to the error output failed with error code 0x80070057.

第二个错误:

SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (86) failed with error code 0xC0209022 while processing input "OLE DB Destination Input" (99). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

然后:

Setting the end of rowset for the buffer failed with error code 0xC0047020

然后:

SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on returned error code 0xC0209017. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

不知道可能是什么问题。

同一个包在几天前运行良好。

提前致谢。

Answer 1

我遇到了类似的问题并完成了以下问题。

在 SQL SERVER CONNECTION PROPERTY 中，尝试将“NO COUNT”选项设置为“OFF”，看看是否可以解决您的问题？