Or you could just use the template task provided for in the XML SSIS Toolkit available at http://www.keelio.cominstead of writing lots of code, SQL, etc to get the same effect.

You could also use a free program like SpiceWorks which does this and a lot more...

Thanks for the article. That is a LOT of steps and code to generate an ATOM RSS feed. You might want to take a look at Keelio Software's...

There is a commercial XML Destination adapter available at http://www.keelio.com that should solve most of your needs for exporting data to XML