Geek asks and answers

SSIS: copying tables from MySQL to SQL Server 2008

I get an error when trying to copy 4 tables from a MySQL source in SQL Server 2008.

Here is a photo of the data stream, as you can see, 2 of them are in order (smaller)

enter image description here

With an event handler, OnErrorI can see errors. Here they are.

SSIS error code DTS_E_OLEDBERROR. An OLE DB error has occurred. error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft Native SQL Server 10.0 Client" Hresult: 0x80040E21 Description: "An OLE DB multi-step operation generates errors. Check each OLE DB status value, if available. There was no operation."

"FechaHoraCorteAgente" (884) " OLE DB" (510). : " , .".

SSIS DTS_E_INDUCEDTRANSFORMFAILUREONERROR. "" OLE DB Destination Input "(510)" , 0xC020907A "OLE DB Destination" "(510)" . . , , .

SSIS DTS_E_PROCESSINPUTFAILED. ProcessInput "OLE DB Destination 2" (497) 0xC0209029 "OLE DB Destination Input" (510). ProcessInput . , . , , .

"ado net conptacto" (1) . HRESULT: 0xC0047020

"ADO NET logllamados" (482) . HRESULT: 0xC0047020

SSIS DTS_E_PRIMEOUTPUTFAILED. PrimeOutput "ado net conptacto" (1) 0xC02090F5. , PrimeOutput(). , , . .

SSIS DTS_E_PRIMEOUTPUTFAILED. PrimeOutput "ADO NET logllamados" (482) 0xC02090F5. , PrimeOutput(). , , . .

, ?

+5
3

0000-00-00 datetime. .

:

(DT_DBTIMESTAMP)(DAY([FechaHoraCorteAgente]) == 0 ? NULL(DT_DBTIMESTAMP) : [FechaHoraCorteAgente])
+3

" , ". , - , . , :

, ,

+5

, , . , , SSIS.

, SSIS , . , ? , , .

In addition, in many cases, when you work with poorly processed source data, you will see personal data in the date time field. Such a scenario will also ruin the package.

+2
source

More articles:


All Articles