April 26th, 2010
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:
I started my SQL career working with SQL Server 2000/2005 for a large MLS Software company in Knoxville,TN. I worked with it for a few years. Now I am a SQL Server Programmer for a large E-Commerce company working with SQL Server 2008 and SSIS. My coworkers and I completed a large data warehouse in November 2009.