sql table to xml

[a0f6459]

Hi,

I'm brand new to xml and webservices. My situation is this. Currently I have a sql server table that is loaded with information every few hours via DTS package. What I need to do is to take the information in the table and convert it to XML to be sent to another company through web services.

Can anyone direct me in the right direction as to how to do this? I understand the concept, but lack the technical knowledge of how to actually do this.

Any help would be greatly appreciated.

Thanks

 

[woogoo]

What version of SQL Server are you using?
--

woogoo

 

[a0f6459]

This is SQL 7.0


I do understand the basics of XML and how it is structured. I just am not sure how to create an xml from a sql table. I'm guessing I would do this using a stored procedure, but I'm not sure.

Thanks in advance.