我正在使用 ODBC 连接在 SSIS 中连接到 MYSQL - 连接成功，但是当执行 SSIS 包时，出现以下错误。
[ODBC Source [30]] Error: SQLSTATE: 22018, Message: [MySQL][ODBC 8.0(a) Driver][mysqld-5.7.30-0ubuntu0.16.04.1]; [ODBC Source [30]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "ODBC Source.Outputs[ODBC Source Output]" failed because error code 0xC020F450 occurred, and the error row disposition on "ODBC Source" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on ODBC Source returned error code 0xC0209029. 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.
我在网上寻找解决方案，但都无济于事。我做了足够的调查，但毫无用处。
提前致谢。
答案1
我不确定为什么会出现此错误，但错误已解决 - 在源 --> 错误输出中，我选择了“忽略失败”作为列