I am doing a project which retrieves data from a AS/400 machine.
The code page of the machine is 420.
I used "OLE DB\IBM DB2 UDB for iSeries IBMDASQL OLE DB Provider" to connect from SQL Server.
The problem is, all the arabic characters coming from this machine becomes unreadable, becoming some machine code text.
What could be the problem and how can I solve this?
Thank you.
Did you try setting the code page value explictly in your ole db source connection?
Thanks
|||
Yes, I'd try to set to 420 in my OLE DB connection, but it still does not work.
I had tried putting nvarchar, add the data conversion in between, using various drivers, ODBC, OLE DB, DB2, iSeries driver, forcing CCSID in AS/400 machine and still unable to extract the data properly.
Would it be the AS/400 problem or my SSIS setting problem?
No comments:
Post a Comment