I am trying to execute a DTS package from Enterprise Manager to import from
an Oracle RDB database into SQL Server 2000. I used to be able to do it when
using SQL Server 7.0, but we have since upgraded to SQL Server 2000 and the
operating system to Windows Server 2003. I don't know when it stopped working
and if those upgrades have anything to do with it.

I have installed the latest ODBC driver - Oracle RDB driver version
3.01.00.01. I can successfully execute DTS packages that import text values,
but if I try to import numeric values I get the error message:
"[Oracle][ODBC][Rdb]%RDB-E-ARITH_EXCEPT, truncation of a numeric value at
runtime -COSI-F-INPCONERR, input conversion error"

The supplier of the Oracle software thinks the problem is to with the
numeric values being the bigint data type, but says that should have been
fixed by the install of the above ODBC driver.

While SQL Server does not seem to like that data type it I can read the data
using Crystal Reports, so my connection to the Oracle database is OK. I have
searched the Oracle and SQL Server web sites and others via Google, but
cannot find a resolution anywhere. Can anyone tell me what to try next?