Hi everyone:

I am importing tables from Oracle 8i from SQL 2000. As means for importing,
I am using the Oracle Odbc Driver. After importing, the values on a numeric
field are returned as 0. I used SQL plus to verify the values and the values
are non zero (mostly positive values).

Why is the dts causing this?.....What solutions are available?

Thanks in advance

I had to change the driver to connect to the data source. I used the driver
that comes with the installation of the Oracle client. On Windows 2000 it
appears as "Oracle ODBC driver"


"Efrain Flores" <efrainf (AT) rocketmail (DOT) com> wrote