Thanks for your replies.. we need to migrate 3-4 tables in Oracle to MSSQL and refresh the data on an ongoing basis.

There are about 50000 records in each table and the script should be able to truncate the table first and then refresh the data from Oracle via the existing linked server..

We cannot use a view to point to the Oracle data as they are on different network and every time we query the view, it goes through the linked server and we are trying to avoid that.... Not sure if there is something like materialized views in MSSQl..

Please help..

Thanks a lot