Copy tables between 2 SQL Servers

Hello All,
I have a requirement wherein have 2 sql server databases(say machine1 & machine2).
I want to run a sql query on machine1 , which would copy 5 tables in a 'XYZ' database on machine2

TO 'XYZ' database on machine1.
Note : I have user/password for both the machines.

I tried this using BCP utility, but problem using BCP is, exceptions cannot be handled And if

there is a network failure during the process of data transfer , the process console window

window of BCP utility, remains still(stuck) and needs user input to continue.

Please send me a QUERY(I already know about the Export/Import in SQL Server Enterprise

Manager, but i need a query to run from vc++) to copy tables between 2 sql servers. that query, i

should be able to place between BEGIN & COMMIT Transaction Process.

Waiting for ur reply.

Regards,
Prax.