Copy table to another server

Hi all,

Does anyone know if there is possible to copy table from a DB in server 1 to a DB in server 2, just like in Import/Export Wizzard but through a script job? Server 2 is "hot" and I am not allowed to use BCP to execut a job locally on Server 2 to import data, but only to export data from Server 2 to Server 1.
I need to know what is the instrument that could do this job.

Thanks in advance.
74SYL

Create linked server and you can copy table with 'inster ... select ... from ...' via linked server.

Thanks for idea, rmiao. I already tried in this way but "insert ..." creates logs on Server 2 and this is unacceptable. I just need to schedule Import/Export Wizzard to copy a table from Server 1 to Server 2 at a specified time. Or to put in a script job what the Wizzard actually does.
Because Import/Export Wizzard is the only way which doesn't affect Server 2, according to my observations (or maybe is there other way?).

All this time the solution was under my nose. SSIS pakage can do the required job. It works great!
Thanks again rmiao!