What I have done in a similar situation is: create a temp database, select * into temp.temptable, backup the db, restore it on the target instance and use it there to copy data.

Also a linked server might be an option.