Save SQL Query to XML

What's the best way to run a SQL query and save it to an XML file?

Use the For Xml clause in your Sql Query, and then route it to a Flat File destination.

For more information on For Xml: http://msdn2.microsoft.com/en-us/library/ms188273.aspx

|||That's easy enough. Thanks|||

Can you mark my post as Answered?

Thanks, it makes it easier to see which threads are pending, and which ones are answered.