For Remote Server whether it be Oracle AS400 DB2 or whatever the Linked Server can be terribly slow.

Depending upon the amount of data you are pulling it may be faster to pull the Data into a SQL Server Staging table and then JOIN with the SQL Server Tables in an EXEC Task.

I had a Contractor that was trying to load a 13 million record table using a linked server.

I tried to convince him to avoid using the Linked Server.

He attempted to the table all week and it did not finish.

Finally I created an SSIS Pacakge and I loaded the table in just over an hour.