Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2007-11-15 : 20:51:37
|
| Hello All,I have process that load data from Oracle 9i to SQL Server 2000, the problem I’m having is the 8-digit numeric value gets truncated to some weird character with a “+” sign. The 4-digit numeric value comes over correctly. The entire process was working properly before the upgrade from Oracle 8i to Oracle 9i. Does anyone know what function I can use on the script to convert the weird char to 8-digit number before loading it to SQL Server table? The column in question has a data type of “nvarchar” and a length on 384…Below is an example of the data that I’m retrieving. Any advice would be greatly appreciated. Thanks. Sample Data938249307.40104e+0076.25001e+00148567.40057e+007 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-15 : 23:17:22
|
| Just load them into numeric type column in sql table. |
 |
|
|
|
|
|
Converting data type from Oracle 9i to SQL Server