Loading using Oracle OLEDB-Error reading number format
When I try to load the data using Oracle provider for OLEDB conection, it reads all the numbers as integers and appends .000000000000......... for all the number columns. If I load same with Mircosoft OLEDB provider for Oracle it is reading numbers correctly. The data type is always a number. Other than using Num function when loading is there a solution with using Oracle provider for OLEDB? Not sure why it is reading numbers as integers. Any help is appreciated.