Oracle LONG data type transfer issues | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Oracle LONG data type transfer issues

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…
You might use TEXT data type in SQL Server to see it fits.
http://www.sqlservercentral.com/columnists/hji/oracleandsqlserverdatainteroperabilityissuespart1.asp fyi. 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.
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?
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.
]]>