We tried to download data from AS400, using SSIS into Database SQL2005/ DTS into database SQL 2000.
In Query Analyzer or Enterprise Manager, we are unable to see data display in chinese characters.
All the columns are set to nchar or nvarchar data types.
If we retrieve the data directly thru ODBC using EXCEL, we are able to see the chinese characters display correctly.
Can I know how to fix the above issue?