Migrating every table to a new linked server has too many prefixes
According to SELECT - INTO Clause


  You cannot create new_table on a remote server using SELECT INTO


In other words, the superfluous prefix is the remote server

You could probably achieve your goal by creating empty tables on the remote server and alter your dynamic SQL to 

INSERT INTO server.database.schema.table select from source