What would be the best ways of updating an oracle table from a query in SQL server? Would I need to create a SQL table from the query then update the oracle table?
I know one option would be to use Linked Servers but I have heard there are security concerns with this method. Would creating an SSIS package be the most suitable method?