I'm using SQL 2005 (SSIS - Integration services) to connect to Oracle R12 using Oracle Drivers. Data appears to be OK on both the Oracle and SQL server DB but on the SQL server Database, precision values are not displayed.
I have a $94.50 on a particular DB view in Oracle
When queried the same table in SQL server 2005 (SSIS), the same value is shown as $94
Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!