Not sure if this can be done. I have a query that I can run, which uses data in tables from one server (local) and joins them from data on a linked server which is in another physical location.
The query runs fine, but when I try to use an import wizard to schedule this query, it will not parse the query because it says it cannot find the table name of the local server in the linked server.
I assume this is because the remote server does not have a linked server back to my local one? Do I need to add my local server as a linked server in the linked server?
Or am I just not referencing the query correctly?
Any help is appreciated, thanks!