I am trying to migrate data from Oracle to sql2005. I use the import/export wizard and ssis. No matter what tool I use, I am encountering issues where the data type on the Oracle is NUMBER 38. In Oracle looks data type number means it is a float datatype. The import/export wizard thinks this is a decimal datatype. As a result the digits right of the decimal are not imgrated over-even though the destination column data type has been defined as float. Has any else encountered this issue? What is the work around?Any input would be most appreciated.