SQL Server Performance Forum – Threads Archive

any limit when you transfer a table?

Hi! I’d like to know if there are any limit when you transfer a table from SQL Server 7.0 to an Oracle database. I did some DTS without any problem but i have a table with 38 columns and i can`t find why i can’t transfer it to Oracle completely.
At last, i did transfer only 31 columns. I would like to know if there is any configuration parameter in DTS package and how i can change it in order to tranfer the whole table, with its 38 columns. Thanks a lot!
MARTA.

---

This works fine in SQL Server, so I suspect it is an Oracle-related issue. I don’t have any experience with Oracle, so I can’t offer any specific advice. If you can’t find a solution, one option would be to export the data from SQL Server in the comma-delimited format, then import it into Oracle. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

---

]]>