Moving data from SQl Server to IBM AS400
-
I am having a problem moving data from an OLE DB source (Sql Server 2012) to a ODBC Destination (IBM Iseries as400) I get the following error messages:
[ODBC Destination [11]] Error: Open Database Connectivity (ODBC) error occurred. state: '22018'. Native Error Code: 30200. [IBM][System i Access ODBC Driver]Column 5: CWBNL0107 - Converted 10 bytes, 5 errors found beginning at offset 0 (scp=1202 tcp=37 siso=1 pad=4 sl=10 tl=10)
[ODBC Destination [11]] Error: Open Database Connectivity (ODBC) error occurred. state: '22018'. Native Error Code: 30019. [IBM][System i Access ODBC Driver]Error in assignment.
Any Ideas as to what might be the issue. I have narrowed it down to a data typing problem. or an unsupported character.
Any help would be greatly appreciated.
-
It looks like I found the problem. When I changed the datetime columns on the SQL side and converted them to Date because that is the data type on the IBM side....and it worked! column 5 in the error message was not the problem it was the column immediately after which was a date column.
-
paulze2000 (3/17/2015)
It looks like I found the problem. When I changed the datetime columns on the SQL side and converted them to Date because that is the data type on the IBM side....and it worked! column 5 in the error message was not the problem it was the column immediately after which was a date column.Quick question, what's the AS/400 O/S and Driver version, seen similar problems before?
-
its IBM I 7.1.This is the first time I ran into the problem because it is the first time I needed to move data from sq lserver to there.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply