I posted a similar question, and I think I need to break it up a bit. I need to create an xml template and populate it with data from a SQL 2005. I am really a newbie when it comes to xml. I just need to know, how to get my data in the format listed. After my data is in there, I think I can use SSIS to generate a variable fixed length file. The lengths of each field is located in my xml document. Any help you can provided will be appreciated. For now, I just need to know how to populate the data with the format listed.