51CTO技术论坛 » 微软SQL Server专区 » 微软商务智能 » 請哪位好心人幫忙看一下        上一帖     下一帖    查看完整版本

页: [1]

denyanfeng2008-3-13 08:53
請哪位好心人幫忙看一下

初學者,請哪位好心人幫忙看一下是什麼原因,謝謝了
Error: 0xC0202009 at 數據清洗和加載, OLE DB Destination 1 [1959]: 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".
Error: 0xC020901C at 數據清洗和加載, OLE DB Destination 1 [1959]: There was an error with input column "LastName" (2079) on input "OLE DB Destination Input" (1972). The column status returned was: "The value could not be converted because of a potential loss of data.".
Error: 0xC0209029 at 數據清洗和加載, OLE DB Destination 1 [1959]: The "input "OLE DB Destination Input" (1972)" failed because error code 0xC0209077 occurred, and the error row disposition on "input "OLE DB Destination Input" (1972)" specifies failure on error. An error occurred on the specified object of the specified component.
Error: 0xC0047022 at 數據清洗和加載, DTS.Pipeline: The ProcessInput method on component "OLE DB Destination 1" (1959) failed with error code 0xC0209029. 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.
Error: 0xC0047021 at 數據清洗和加載, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0209029.
Information: 0x40043008 at 數據清洗和加載, DTS.Pipeline: Post Execute phase is beginning.

xingd2008-3-17 03:43
数据转换失败,检查下LastName字段转换的类型。

denyanfeng2008-3-18 10:05
憶經解決掉了,是數據長度太短了,所以才會出現那樣的問題,謝謝你的回復

skyrian0012008-10-15 09:34
学习了!

kdscnu2008-11-9 02:43
谢谢楼主共享

关键词: cat       

相关文章:
FreeBSD中/etc下的文件简介
微软与教育部携手助学
教你打造一道超级防御的电脑防火墙
设计标准的BI报表
关于Cisco 1811路由器PPPOE设置的问题

查看完整版本: 請哪位好心人幫忙看一下


Powered by 51CTO.COM