May be you should use SQL Server Integration Services. Set up a data flow task, get data from Oracle and push it to a SQL Server table. You may not even need to write code, but there may be some data conversions needed which can also be configured in SSIS. If you are not proficient in the use of SSIS...