i have a DTS package which copies data from sybase database to oracle 9i the field type number(6,3) in sybase and oracle. we are doing a simple table copy using DTS transformation using source as sybase table and destination as oracle table.the copy is all fine except for the data when there is no decimal value and the absolute value is divisible by 10 suppose if data coming from table 40 or 60 or 80 it transforms it into 0 if the incoming data is 73 or any such number its fine its copied as 73 if incoming number is like 36.456 its fine
any ideas on what could be happening