try looking into remote procedure calls.
Call up a stored proc or do a select from server X but on server Y (requires that they have been linked) then output the stored procedure or select to the local server X.
select into test * from (Server Name).(Database Name).(Owner).(Table Name)
run this on the server you want to move the data to, not from.