I need to transfer data from a table in SQL Server to a file inAS 400 server. I am using the provider Microsoft OLE DB provider for DB2. When trying to execute the package I am getting the following error message: [OLE DB Destination [3643]] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft DB2 OLE DB Provider" Hresult: 0x80040E14 Description: "Character in CAST argument not valid. SQLSTATE: 22018, SQLCODE: -420". [OLE DB Destination [3643]] Error: The "input "OLE DB Destination Input" (3656)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (3656)" specifies failure on error. An error occurred on the specified object of the specified component. [DTS.Pipeline] Error: The ProcessInput method on component "OLE DB Destination" (3643) failed with error code 0xC0209029. 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. [DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0209029. Initially I thought like this is a casting issue. But I tried transferring data from one column. Then also I am getting the same error. The package gets failed in OLE DB Destination. It succesfully executes in OLE DB source. Expecting a reply on this.

What is the type, in SSIS, of the column that is giving you the problem? What is the type, in DB2, of the column that is giving you the problem?

Hi, Probably you have a mistake in your SQL Statement. The error you are receiving is the following DB2 error: SQLCODE -420, Error: THE VALUE OF A CHARACTER STRING ARGUMENT WAS NOT ACCEPTABLE TO THE FUNCTION So try to look better into your statement. Regards

This problem happens if not all destination columns are being mapped. So, you need to check if there are <ignore> items in oledb destination column mapping that should be linked to the colums of the destination. Also, the oledb source should pass the exact width of the columns being mapped to avoid warnings related to truncation. JB

Barbosa26's solution works for this.. Thanks!