We tried exporting the data (sqlsvr7) to a flat file and using sqlldr. Not working. The dts package will connect to the table in oracle but there is over 8Gb of data and we want to speed this up. Is there a method to export the binary data to a flatfile that preserves the binary format such that we can move that up to linux and subsequently into the oracle instance? Any help would be greatly appreciated

Sincerely

AW

Any thought of using a linked server relationship between the Oracle db and the SQL Server db? As long as the datatypes are compatible (ANSI or close), then you should be able to get away with it. Otherwise, BCP on the SQL Server side and SQL*Loader on the Oracle side. Neither is speedy, so you'll have to experiment

Regards
John Miclei

Thank you John. I appreciate your time and response

TA