Hello, i have to make an import of data from oracle to a sql server database for a warehouse. The data import involve complex queries, so i need to use cursors, subqueries etc.

What would be the best way to do the import? to make dts with activeX task, a dts that call an oracle stored procedure or to make a linked server with the oracle db and use sql server cursors?