Hi,

I have to get data from a webservice into an SQLserver database. I was just wondering if SQL server can directly access the webservice and read the data, or do i have to build a client in .net that accesses the webservice and then imports the data to SQL server.

Also if i use a client, is a windows service a good thing to use as it needs to do this import at regular intervals during the day?

Cheers
Nick