I am running SQL Server 7.0 and currently testing Host Integration Server to copy tables from a database on an AS/400. I have configured the Microsoft ODBC Driver for DB/2 as my Data Source.

When I try to import a table, the import begins but I receive the following error msg " Error at Destination for Row number xxxx Arithmetic overflow error converting numeric to data type numeric".

I can download the same table via SNA Server using the STAR SQL ODBC driver on another without error but not between the AS400 and the server. I cannot figure out what could be wrong. Any help would be appreciated.