Linked Servers security context and transaction logging
Don't use a linked server for this. It will likely be slow. Linked servers are suitable for small queries over remote databases, not for bulk loading data. 

I would use SSIS or whichever ETL system you feel more comfortable with.