在使用SSIS从MySQL迁移数据到SQL Server 2008的过程中，遇到多个错误，包括OLE DB错误0x80040E21，涉及'FechaHoraCorteAgente'列的数据溢出问题，导致数据流任务失败。错误发生在'OLE DB Destination Input'组件上，同时'ado net conptacto'和'ADO NET logllamados'组件也报告了无法处理数据的问题，返回HRESULT异常0xC0047020和0xC02090F5。
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error
code: 0x80040E21. An OLE DB record is available. Source: “Microsoft
SQL Server Native Client 10.0” Hresult: 0x80040E21 Description:
“Multiple-step OLE DB operation generated errors. Check each OLE DB
status value,if available. No work was done.”.
There was an error with input column “FechaHoraCorteAgente” (884) on
input “OLE DB Destination Input” (510). The column status returned
was: “Conversion failed because the data value overflowed the
specified type.”.
SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The “input “OLE
DB Destination Input” (510)” failed because error code 0xC020907A
occurred,and the error row disposition on “input “OLE DB Destination
Input” (510)” specifies failure on error. An error occurred on the
specified object of the specified component
最低0.47元/天 解锁文章
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
