Home Forums Data Warehousing Data Transformation Services (DTS) importing data from as/400 to sql server 2005 RE: importing data from as/400 to sql server 2005
Norman Kelm
SSCommitted
Points: 1922
More actions
February 12, 2008 at 7:15 am
#777327
Is the AlwaysUseDefaultCodePage property set to True on the AS400 Data Source Task?
Which driver is being used, IBM's OLEDB or MS OLEDB for DB2?
Also examine the CCSID for column using the iSeries Navigator. Is it 37?
Norman
DTS Package Search
http://www.dtspackagesearch.com/