Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: sybase to oracle copy

    i have a DTS package which copies data from sybase database to oracle 9i the field type number(6,3) in sybase and oracle. we are doing a simple table copy using DTS transformation using source as sybase table and destination as oracle table.the copy is all fine except for the data when there is no decimal value and the absolute value is divisible by 10 suppose if data coming from table 40 or 60 or 80 it transforms it into 0 if the incoming data is 73 or any such number its fine its copied as 73 if incoming number is like 36.456 its fine
    any ideas on what could be happening

  2. #2
    Join Date
    Nov 2002

    Re: sybase to oracle copy

    Install last EBFs of Sybase ASE and sybase Open Client to prevent old bcp API bugs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts