Import data from Oracle to SQL Server I have an Oracle database in a remote server. I want to import data from it to SQL Server on a local machine using a stored procedure or job shedule but I don't know how can I do it.
Here you have nice article how to link oracle to your SQL Server and query it.

For data import you can you SELECT INTO statement or make SSIS package for that.