February 22, 2004 at 1:38 pm
Hi
I am using dts import copy table from oracle server to sql2k database.
I have imported successfully all the rows, but all the numeric fields are zeros.
Can some one help me.... i tried search mirosoft site / google, but no luck...
Rohit
RJPATEL
February 23, 2004 at 10:32 am
Have you checked the data type on the Oracle side matches the data type on the SQL Server side. You might have to either change the column data type or use the cast function to get the data across.
February 23, 2004 at 11:39 am
Hi Stacenic
it should not be like that numeric should tranfer numeric.
it works if I use to_char function.
someone suggested to apply service pack 3.
I am going to try that...
RJPATEL
February 23, 2004 at 11:42 am
Check the scale and precision for both sides.
February 23, 2004 at 11:49 am
yes, it does match exactly
RJPATEL
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply