• Your problem may be due to the way your database servers was set up and ssis performing row-by-row inserts vs mass insert using a sql query. Now what about a hybrid solution here?

    Copy your linked server query into an 'Execute SQL' task in SSIS. That way you get the best of both worlds!;-)