Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Oracle Sql*Loader Control files to Sql Server 2000

Author  Topic 

byronbush
Starting Member

1 Post

Posted - 2006-03-30 : 13:14:46
I'm new to SS 2000 but an old hand at Oracle. My business problem is converting the load process for about 400 Oracle tables to SS 2000. I have raw data files and 400+ Sql*Loader control files. We have been working with the DTS GUI/UI to manually define our loads; we're finding this very frustrating as the UI is less-than-desirable and time consuming. Is anyone aware of a way to convert our Sql*Loader control files to something SS 2000 can use? Your advise would be greatly appreciated. Mahalo, BBBush
   

- Advertisement -