我正在尝试将一个SQL Server 2012数据库导出到PostgreSQL 9.3中,但是在浮点数列上遇到了奇怪的转换错误。如果忽略浮点数列进行导入,一切都会很顺利(大约300k行),否则我会收到以下警告:
- Copy in "TABLE_TO_COPY" (Error)
Messagges
Error 0xc020844b: Data Flow Task 1: Exception during data insertion. The message returned by the provider is: Unable to cast object of type 'System.Double' to type 'System.Char[]'.
(SQL Server Import and Export Wizard)
Errore 0xc0047022: Data Flow Task 1: Error Code SSIS DTS_E_PROCESSINPUTFAILED. Error in method ProcessInput in component "Destination - TABLE_TO_COPY" (94) with code 0xC020844B during the processing of the input "Destination Input" (97). The specified component returned an error from the method ProcessInput. [...]
Error 0xc02020c4: Data Flow Task 1: Attempt to add a row to the buffer of activity Data flow errored with code 0xC0047020. [...]
(SQL Server Import and Export Wizard)
Error 0xc0047038: Data Flow Task 1: Error Code SSIS DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Origin - PATIENT_DIALYSIS_SYMPTOM returned error code 0xC02020C4. 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)
这不是内存问题,因为服务器设置已经达到了最高值。可能是什么原因导致的呢?