I am developing a vb.net windows application.The backend is sql server2000.
presently company is receiving data in email format. the data entry person
checks the email every hour and enter the new info to the application/db. in
the future the website company will send the data in xml format.
my question:
1)how to write a windows application that listen continuously and receive
incoming xml data from this website and put the data to sql server 2000?
2)is there any built feature in sql server to do this?
3)any advice?
thanks

October 7, 2006

An easy way is for the other company to send you the information through a
web service. The web service can handle multiple calls at the same time, and
your custom logic can insert the data into the SQL DBs. Also, the web
service can run under IIS which makes administration easier.

I'm not sure whether there is a for-sure feature of SQL which can do this...
but Biztalk may be able to help in this case. - You'd have to research more
about this idea because I'm not sure.

--

Joseph Bittman
Microsoft Certified Solution Developer
Microsoft Most Valuable Professional -- DPM

Blog/Web Site: http://CactiDevelopers.ResDev.Net/
"srid" <srid (AT) discussions (DOT) microsoft.com> wrote

thx for the info. i am doing some research on .net namespace

"Joseph Bittman MVP MCSD" wrote: