We have MSSQL08R2 and have a new business requirement to send a few individual records via web service calls to an external web service as a nightly job. I've been reading the documentation for Native XML Web Services in MSSQL08, but it seems like that is intended for exposing our sql server as its own web service for external apps to access. I need to do the opposite: send our data to an external web service at a specific time (and commit the transaction when I get the acknowledgement response). Do I need to create an endpoint using native xml web services just to transmit these records to the external web service, or is there an easier way to do this?

Any links to examples of how to do this?