ssis包由来自SQL2000服务器源数据库的OLED源和OLEDB destination.Extract数据组成,并将其加载到相同的数据库目标数据库table.while中,加载400万行,在加载300万行后出错。使用ssis加载这些记录需要4个小时...请参阅下面的错误
[ SSIS 737]错误:Ae_Data错误代码DTS_E_OLEDBERROR。发生OLE DB错误。错误码: 0x80004005。OLE DB记录可用。来源:"Microsoft SQL Server Native Client 10.0“Hresult: 0x80004005描述:"Unspecified error”。
[ SSIS 737]错误:Ae_Data错误代码DTS_E_INDUCEDTRANSFORMFAILUREONERROR。由于出现错误代码0xC020907B," Input“OLE DB Destination Input”(750)“失败,并且"input "OLE DB Destination Input”(750)“上的错误行处理指定出错时失败。指定组件的指定对象出错。在此之前可能会发布错误消息,其中包含有关故障的更多信息。
发布于 2013-09-03 21:37:26
尝试将其更改为ADO.NET目标
发布于 2020-09-16 22:03:29
我今天遇到了类似的问题,网上的帖子对我都没问题。我遇到的错误和你的类似。我发帖子是为了防止其他人遇到同样的问题
Error: 0xC0202009 at Get fresh data, OLE DB Destination [2]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Unspecified error".
Error: 0xC0209029 at Get fresh data, OLE DB Destination [2]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "OLE DB Destination.Inputs[OLE DB Destination Input]" failed because error code 0xC020907B occurred, and the error row disposition on "OLE DB Destination.Inputs[OLE DB Destination Input]" 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.
Error: 0xC0047022 at Get fresh data, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (2) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (15). 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. There may be error messages posted before this with more information about the failure.
在执行从一个表到另一个表的OLE DB传输时,会发生这种情况。问题出在目标的表索引上
尝试向下钻取导致问题的特定记录,并确定导致问题的字段。我通过一些试验和错误成功做到了这一点。通过修改源sql查询来选择不同的字段,直到我找出哪些字段给我带来了插入问题。
然后删除该特定目标上的所有相关索引,它就可以工作了
https://stackoverflow.com/questions/18387790
复制相似问题