SQL server跨库导表的有关问题
SQL server跨库导表的问题
大家好，问题是这样的：
我从服务器上的实例里的数据库导出里面一个表到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)
------解决方案--------------------
Description: "Invalid column value from bcp client for colid 13.".
是不是colid 13数据格式有问题？
------解决方案--------------------
呵呵 SSIS可以调整CODE PAGE，参考：
http://msdn.microsoft.com/zh-cn/library/ms141704(v=SQL.100).aspx
大家好，问题是这样的：
我从服务器上的实例里的数据库导出里面一个表到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)
sql server
------解决方案--------------------
Description: "Invalid column value from bcp client for colid 13.".
是不是colid 13数据格式有问题？
------解决方案--------------------
呵呵 SSIS可以调整CODE PAGE，参考：
http://msdn.microsoft.com/zh-cn/library/ms141704(v=SQL.100).aspx