在尝试从Oracle 10g导入数据到SQL Server 2005时遇到错误，具体为数据流任务中的OLE DB错误，提示日期字段'EFFCHGDT'的转换失败，原因是数据值溢出指定类型。该问题在SQL Server 2008上不存在，可能与Oracle的日期格式不兼容。寻求解决SQL Server 2005导入过程中日期字段问题的方法。
我一直在尝试使用任务导入向导将一个表从Oracle 10g导入到SQL Server 2005中,但始终出现以下错误:
- Copying to [PersonDB].[PEOPLE] (Error)
Messages
Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification".
(SQL Server Import and Export Wizard)
Error 0xc020901c: Data Flow Task: There was an error with input column "EFFCHGDT" (416) on input "Destination Input" (269). The column status returned was: "Conversion failed because the data value overflowed the specified type.".
(SQL Server Import and Export Wizard)
Error 0xc0209029: Data Flow Task: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (269)" failed because error
最低0.47元/天 解锁文章
1644
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
