Discussion Locked

DTS and Long Datatypes

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have used DTS to convert Oracle 7 databases to SQL Server 7 databases. However, the data from the Long datatypes (Oracle) do not get converted. Is there a way to do this from DTS or do you know of another way to handle this?

1 reply

by scottyb

I have a work-around, but it's kind of a pain. I select all the data from an Oracle table and keep it in an ASCII file. Then, I import the data into SQL Server using the bcp command. Any other suggestions?

This discussion is closed to new replies.