Click here to Skip to main content
15,664,823 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Can anyone help? I have a requirement to export some data from SQL server 2008 into XML format, then automatically save the results from my SQL query into as a .XML file, then convert this file using XSLT and lastly I need to post the converted file to a web service.

I have managed to retrieve the data into XML, save the results as a .XML file

I cannot figure out how to automatically send the data to a web service. I would love some code which states: If file exists then post.

I know the URL to send the .xml to and my file is in the correct format.

I imagine I would need to use some form of VB code, but I am a complete novice with VB. I have access to Visual Studio, but no real idea how to use it or how to deploy a project. If any one could offer up a solution I would be extremely grateful.

1 solution

When you are in doubt, remember that Google can definitely help you get started.
See these links:
XML Support in Microsoft SQL Server 2005[^]
Google search - sql to xml[^]
Google search - how to send data to a web service[^]

And yes, you can write code in any language to use a web service. It is language independent. Your data just needs to be serialised and follow the web service standards and formats.

Hope this gives you a start!
Share this answer
walterhevedeich 20-Aug-11 7:27am    
Well said.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900