XML say wha?


I am working on a project where I need to export XML from my database, in the process of asking for help I decided I would document here (a similar version of what I am working on) what I was stuck on and ask for help in my comments since twitter #sqlhelp needed more info.

I am currently trying to use FOR XML EXPLICIT to pull this data but have realized that I might  be using the wrong tool. We have other feeds written in C#, I was just trying to get around the script task in SSIS.

Here you go:

xml_blog.txt