error saat mau export data dari sql server ke mysql(localhost)

halo gan, disini saya mau nyoba export dari sql server ke mysql selalu gagal, udh nyoba ngikutin stackflow ttp error.

kebetulan saya udh nyoba pake 2 cara export.

(1). ini pake cara umum sql service native client ==> data provider for MySQL (error)

(2). ini pake cara stackflow https://stackoverflow.com/questions/20633244/insert-into-table-mysql. pake data provider odbc => data provider mysql.(errornya sama)

ScreenShoot = https://ibb.co/FD6XKXC

hasilnya sama2 error gan. ada solusi kah? atau agan2 tau cara/tempat buat covert dari dbf ke sql, kebetulan data yg ada di dbf ada setikar 30rb rows, jd mau pake aplikasi gratis gak ngangkat gan.

(error massage nya gan)

- Copying to "CUST" (Error)

Messages

Error 0xc020844b: Data Flow Task 1: An exception has occurred during data insertion, the message returned from the provider is: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"CUST" ("PFKDCUST", "PFNAMA", "PFALAMAT", "PFJIDEN", "PFNOIDEN", "PFJKEL", "PFTM' at line 1

(SQL Server Import and Export Wizard)

Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Destination - CUST" (76) failed with error code 0xC020844B while processing input "Destination Input" (79). 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.

(SQL Server Import and Export Wizard)

Error 0xc02090f5: Data Flow Task 1: The Source - CUST was unable to process the data. Exception from HRESULT: 0xC0047020

(SQL Server Import and Export Wizard)

Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on Source - CUST returned error code 0xC02090F5.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.

(SQL Server Import and Export Wizard)

avatar dynemix
@dynemix

43 Kontribusi 5 Poin

Dipost 3 tahun yang lalu

Belum ada Jawaban. Jadi yang pertama Jawaban

Login untuk ikut Jawaban