SSIS 转型 - 从 SQL Server 到 AS400

Question

我们正在尝试将数据从 Microsoft SQL Server 传输到 AS400 系统。如果使用 OLE DB 目标组件（通过 IBM OLE DB 驱动程序），数据将成功从 SQL Server 传输到 AS400。

由于 OLE DB 需要更多时间来传输数据，因此我们决定修改目标以使用 ADO.NET。如果我们将 ADO.NET Destination 组件与 IBM .NET 驱动程序一起使用，SSIS 会引发一般数据转换错误。我们的包裹也很简单，只有来源和目的地。

同样，OLE DB 目标工作正常，但使用 ADO.NET 目标进行相同的输入时，我们收到错误。

Detailed error msg:
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  
The ProcessInput method on component "DEST - FACT BILL" (1698) failed with error code 0xC020844B 
while processing input "ADO NET Destination Input" (1701). 
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.


[DEST - FACT BILL [1698]] Error: An exception has occurred during data insertion, 
the message returned from the provider is: SQL0189: Coded Character Set Identifier 37 not valid.
Cause . . . . . :   Coded Character Set Identifier (CCSID) 37 is not valid for one of the following reasons: -- 
The CCSID is not EBCDIC. -- The CCSID is not supported by the system. -- The CCSID is not valid for the data type. -- 
If the CCSID is specified for graphic data, then the CCSID must be a DBCS CCSID. -- 
If the CCSID is specified for UCS-2 or UTF-16 data, then the CCSID must be a UCS-2 or UTF-16 CCSID. -- 
If the CCSID is specified for CLOB, DBCLOB or DATALINK data, then the CCSID must not be 65535. -- 
If there are multiple DataLink columns with FILE LINK CONTROL, they must all have the same CCSID. -- 
The NORMALIZED clause can only be specified for a UTF-8 or UTF-16 CCSID. Recovery  . . . :   
Ensure that all CCSID values in the statement are supported by the system and are valid for the data type. 
For a list of valid CCSID values, refer to the DB2 UDB for iSeries SQL Reference topic in the Information Center, 
http://www.ibm.com/eserver/iseries/infocenter.

如果有人以前见过这个错误，请告诉我，我该如何解决这个问题？

Answer 1

为什么说OLEDB需要更多时间呢？我专门在 ETL 流程中使用这些组件，并取得了非常好的结果。