SQL server跨库导表的问题

[fongkey]

大家好，问题是这样的：
我从服务器上的实例里的数据库导出里面一个表到local实例的数据库里。但是最后在copy时都报错为。请大家帮忙分析一下原因。

- Copying to [dbo].[TblPartLookUp] (Error)
Messages
Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Invalid column value from bcp client for colid 13.".
(SQL Server Import and Export Wizard)

Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (68)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Destination Input" (68)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)

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

[KevinLiu]

Description: "Invalid column value from bcp client for colid 13.". 是不是colid 13数据格式有问题？

[fongkey]

我试验了一下，将源表删除列到只剩下两列，就复制成功。但如果源表为三列以上时会报错为： 里面说code page1252 and 936。我不知怎样设置。 - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Error) Messages * Error 0xc02020f4: Data Flow Task 1: The column "SerialNumber" cannot be processed because more than one code page (1252 and 936) are specified for it. (SQL Server Import and Export Wizard) * Error 0xc02020f4: Data Flow Task 1: The column "PartNumber" cannot be processed because more than one code page (1252 and 936) are specified for it. (SQL Server Import and Export Wizard) * Error 0xc02020f4: Data Flow Task 1: The column "PartDesc" cannot be processed because more than one code page (1252 and 936) are specified for it. (SQL Server Import and Export Wizard) * Error 0xc02020f4: Data Flow Task 1: The column "WarehouseCode" cannot be processed because more than one code page (1252 and 936) are specified for it. (SQL Server Import and Export Wizard) * Error 0xc02020f4: Data Flow Task 1: The column "BusinessUnit" cannot be processed because more than one code page (1252 and 936) are specified for it. (SQL Server Import and Export Wizard) * Error 0xc02020f4: Data Flow Task 1: The column "ProductLine" cannot be processed because more than one code page (1252 and 936) are specified for it. (SQL Server Import and Export Wizard) * Error 0xc02020f4: Data Flow Task 1: The column "ProductFamily" cannot be processed because more than one code page (1252 and 936) are specified for it. (SQL Server Import and Export Wizard) * Error 0xc02020f4: Data Flow Task 1: The column "RepairStatus" cannot be processed because more than one code page (1252 and 936) are specified for it. (SQL Server Import and Export Wizard) * Error 0xc02020f4: Data Flow Task 1: The column "RMANumber" cannot be processed because more than one code page (1252 and 936) are specified for it. (SQL Server Import and Export Wizard) * Error 0xc02020f4: Data Flow Task 1: The column "Reason" cannot be processed because more than one code page (1252 and 936) are specified for it. (SQL Server Import and Export Wizard) * Error 0xc02020f4: Data Flow Task 1: The column "ProblemDesc" cannot be processed because more than one code page (1252 and 936) are specified for it. (SQL Server Import and Export Wizard) * Error 0xc02020f4: Data Flow Task 1: The column "ProblemRes" cannot be processed because more than one code page (1252 and 936) are specified for it. (SQL Server Import and Export Wizard) * Error 0xc02020f4: Data Flow Task 1: The column "WorkPerformed" cannot be processed because more than one code page (1252 and 936) are specified for it. (SQL Server Import and Export Wizard) * Error 0xc02020f4: Data Flow Task 1: The column "FieldExposure" cannot be processed because more than one code page (1252 and 936) are specified for it. (SQL Server Import and Export Wizard) * Error 0xc004706b: Data Flow Task 1: "component "Destination - TblServiceReturns" (82)" failed validation and returned validation status "VS_ISBROKEN". (SQL Server Import and Export Wizard) * Error 0xc004700c: Data Flow Task 1: One or more component failed validation. (SQL Server Import and Export Wizard) * Error 0xc0024107: Data Flow Task 1: There were errors during task validation. (SQL Server Import and Export Wizard) - Prepare for Execute (Stopped) - Pre-execute (Stopped) - Executing (Success) - Copying to [dbo].[TblServiceReturns] (Stopped) - Post-execute (Stopped)

[KevinLiu]

呵呵 SSIS可以调整CODE PAGE，参考： http://msdn.microsoft.com/zh-cn/library/ms141704(v=SQL.100).aspx

[applealing]

我导入表的时候也碰到了好多错误 - Copying to [dbo].[PMI_Users] (Error) Messages Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "未指定的错误". (SQL Server Import and Export Wizard) Error 0xc020901c: Data Flow Task 1: There was an error with Destination - PMI_Users.Inputs[Destination Input].Columns[userName] on Destination - PMI_Users.Inputs[Destination Input]. The column status returned was: "The value violated the integrity constraints for the column.". (SQL Server Import and Export Wizard) Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Destination - PMI_Users.Inputs[Destination Input]" failed because error code 0xC020907D occurred, and the error row disposition on "Destination - PMI_Users.Inputs[Destination Input]" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. (SQL Server Import and Export Wizard) Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - PMI_Users" (62) failed with error code 0xC0209029 while processing input "Destination Input" (75). 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 0xc02020c4: Data Flow Task 1: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. (SQL Server Import and Export Wizard) Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Source - Sheet3$ 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)