Can you please help...
We have tablet PC's that people use to create forms on(I'm not concerned with this step)
1) The tablets generate small 5-10 kb XML code files.
2) These are uploaded to a Server #1 on site #1
3) I have to design a system to automate the pulling of this code, then the transformation of it into some form of SQL so it can be plugged into the database on site # 2 and database on site # 3.
Any tips? Specifically with how to automate the pulling from the server...how to interrogate/get notified when the db server has received the XML code( the form )