Forgot to mention a few more things:

1.  Yes, we are planning to remove the link server.  Very inefficient  and unacceptable especially when joining to local data warehouse tables.
2. The code...