how to get XML from another company

[nicole08]

hi all,

we would like to get an XML file from another company every day, and save it to our database. what shall i do?

the following is my solution, but i'm not sure about them:

option 1: as that company send us email including XML

option 2: MSMQ

option 3: SOAP

or something else??

Help needed cincerely. Thanks in advance.

Nicole

 

[durug]

If you have SQL 2000 you can create a page where the user is uploading every day the xml document and you will parse the file using OPENXML directly to the DB.

If the company has a lot of money the use BizTalk and MSMQ. This is the future of XML data communication

Check this site, has a lot of info about XML and SQL

http://www.sqlxml.org

Regards,
Durug