我正在尝试从Access数据库将超过82k行的表导入到SQL Server 2008。
使用SQL Server导入和导出向导,在输入约78k条记录时出现错误。
以下是错误信息:
Error 0xc0208265: Data Flow Task 1:
Failed to retrieve long data for column "members_notes".
Error 0xc020901c: Data Flow Task 1:
There was an error with output column "members_notes" (41) on output "OLE DB Source Output" (11).
The column status returned was: "DBSTATUS_UNAVAILABLE".
Error 0xc0209029: Data Flow Task 1:
SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.
The "output column "members_notes" (41)" failed because error code 0xC0209071 occurred, and the error row disposition on "output column "members_notes" (41)" specifies failure on error.
Error 0xc0047038: Data Flow Task 1:
SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.
The PrimeOutput method on component "Source - Query" (1) returned error code 0xC0209029.
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.
在访问数据库中,members_notes列是一个备忘录字段。在将这些数据传输到的SQL Server表中,我已将该字段定义为nvarchar(MAX)。
我已搜索此错误消息并找到一些文章建议缩小我的SQL数据库并清除执行导出/导入的计算机上的临时文件,但都没有起作用。
有其他人遇到过这个问题吗?