SQL Server Performance

Oracle LONG data type transfer issues

Discussion in 'SQL Server DTS-Related Questions' started by swarthead, May 22, 2007.

  1. swarthead New Member

    I have created a DTS routine to transfer data from an Oracle 8i to SQLServer 2000 environment, using Oracle 9i's ODBC driver. Everything works fine except the transferring of a LONG data type column. At first the issue was intermittent truncation of the field, which I think I took care of with an Oracle function to convert the LONG to varchar2. Now I'm scratching my head over the data transfer which succeeds but copys only a fraction of the records (typically 65,000 out of 200,000). The DTS routine is only copying this one field.

    Any guidance appreciated...
  2. satya Moderator

  3. swarthead New Member

    Sorry, I should have mentioned that the destination is a text field. Data type, though, doesn't explain the transfer not pulling all the requested records. Sounds like a buffering issue but you would think there would be errors showing up somewhere?
  4. satya Moderator

    Then you should enable the DTS package logging to see where it is failing, similarly on the Oracle side also perform such logging facility. Have you referred to the link above.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page