mysql - SSIS:将表从 MySQL 复制到 SQL Server 2008

Question

我在尝试将 4 个表从 MySQL 源复制到 SQL Server 2008 时遇到错误。

这是数据流的照片，如您所见，其中 2 个都可以(较小的)

通过 OnError 事件处理程序，我能够看到错误。他们在这里。

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Errorcode: 0x80040E21. An OLE DB record is available. Source: "MicrosoftSQL Server Native Client 10.0" Hresult: 0x80040E21 Description:"Multiple-step OLE DB operation generated errors. Check each OLE DBstatus value, if available. No work was done.".

There was an error with input column "FechaHoraCorteAgente" (884) oninput "OLE DB Destination Input" (510). The column status returnedwas: "Conversion failed because the data value overflowed thespecified type.".

SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLEDB Destination Input" (510)" failed because error code 0xC020907Aoccurred, and the error row disposition on "input "OLE DB DestinationInput" (510)" specifies failure on error. An error occurred on thespecified object of the specified component. There may be errormessages posted before this with more information about the failure.

SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method oncomponent "OLE DB Destination 2" (497) failed with error code0xC0209029 while processing input "OLE DB Destination Input" (510).The identified component returned an error from the ProcessInputmethod. The error is specific to the component, but the error isfatal and will cause the Data Flow task to stop running. There maybe error messages posted before this with more information about thefailure.

The component "ado net conptacto" (1) was unable to process the data.Exception from HRESULT: 0xC0047020

The component "ADO NET logllamados" (482) was unable to process thedata. Exception from HRESULT: 0xC0047020

SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method oncomponent "ado net conptacto" (1) returned error code 0xC02090F5.The component returned a failure code when the pipeline engine calledPrimeOutput(). The meaning of the failure code is defined by thecomponent, but the error is fatal and the pipeline stopped executing.There may be error messages posted before this with more informationabout the failure.

SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method oncomponent "ADO NET logllamados" (482) returned error code 0xC02090F5.The component returned a failure code when the pipeline engine calledPrimeOutput(). The meaning of the failure code is defined by thecomponent, but the error is fatal and the pipeline stopped executing.There may be error messages posted before this with more informationabout the failure.

知道这里发生了什么吗？

Answer 1

“转换失败，因为数据值溢出了指定的类型。”看起来很明显，您正试图在不合适的地方插入一些东西。我建议您将所有源列与目标列进行比较，并确保:

• 长度足够了
• 数据类型兼容

如果你想帮忙，你可以发布你的表结构