This video demonstrates a simple technique for outputting data to an XML file using SQL Server Integration Services
Hmm…it looks like things are taking a while to load. Try again?