Hi

What version of sqlserver is it.
If its 2005 then you sqlserver guys can use SSIS which is free to grab data from oracle.

You can also write a C program to generate a flat file from oracle and ftp it to sqlserver .

regards
Hrishy