data transfer using xml

[KNN]

Hello,

I need to create an application that transfers a data table, from my local sql 2005 express database to a remote SQL server through XML.

local server: scream\sqlexpress
table name: test
path: SCREAM\SQLEXPRESS\Databases\System Databases\master\Tables\test.dbo

remote server: testserver\ftpaccess.cc

really need this
thanx

 

[KNN]

c'mon guys i really need this

 

[Raven65]

Why does it have to be XML ? If both servers are running SQL, populate a DataSet from the source and inject it into the destination, seems much simpler. (Provided the destination is set to allow remote connections, which it seems it is)

 

[KNN]

has to be XML because all transmissions have to go through port 80.