There are no indexes on the table and the two columns are nvarchar(256).

In the actual query plan when the INSERT into the staging table is not included the remote...