任务计划程序运行SSIS工作流时出现问题

Question

我的SSIS工作流有点不可靠。

正常过程应如下所示：任务调度程序作业启动批处理文件。批处理文件启动SSIS作业。

此过程会产生以下错误：

Error: 2020-12-08 07:10:43.95

Code: 0xC02090F5
Source: Data Flow Task Connect to Impala [2132]
Description: The component "Connect to Impala" (2132) was unable to process the data. ERROR [08S01] [Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala: [08S01] : SSL_read: error code: 0
End Error
Error: 2020-12-08 07:10:43.95
Code: 0xC0047038
Source: Data Flow Task SSIS.Pipeline
Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "Connect to Impala" (2132) returned error code 0xC02090F5.  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.
End Error

但是，当我启动批处理文件时，SSIS作业会成功执行。即使我在MS Visual Studio中启动作业，也没有任何问题。

谷歌暗示ODBC连接可能存在问题。我使用的是32位ODBC驱动程序Impala(用户DSN(。也尝试过64位，但也不起作用。

我感谢每一个答案。感谢

Answer 1

问题已解决

请参阅此解决方案：https://community.cloudera.com/t5/Support-Questions/ERROR-SSL-read-error-code-0-with-IMPALA-from-R-programming/td-p/280561

它是关于超时参数的。