Post reply

DTS import from oracle table to SQL table

  • February 22, 2004 at 1:38 pm

    #160494

    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

    #495183

    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.


    Shamless self promotion - read my blog http://sirsql.net

  • February 23, 2004 at 11:39 am

    #495189

    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

    #495191

    Check the scale and precision for both sides.


    Shamless self promotion - read my blog http://sirsql.net

  • February 23, 2004 at 11:49 am

    #495194

    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