Hi Myles McKee, is this question related to SSIS? if not please post in SQL Server XML Forum. Shailesh, Please mark the post as answered if it answers your question.

I do not know how you coded your functionality, but it seems that it could be done by having a template file with the <?XML version "1.0"... etc then when you have you XML file produced you issue an append in form say of exec xp_cmdshell 'XMLResult.xml >> XMLHeader.xml'Arthur My Blog

I'm looking for the info to develop an SSIS package, but you're probably right that I'm better off looking for my answer on the SQL Server XML forum - I've moved my question to there. Thanks for the response Arthur. I'll see if I can get that approach to work.Myles McKee

I've developed code for outputting an XML file from SQL Server 2005, now I want to append the row (below) to the top of the file. '<?xml version="1.0" encoding="UTF-8" standalone="no" ?>' Does anyone have SQL code I code use for this situation? Myles McKee

Hi Myles McKee, is this question related to SSIS? if not please post in SQL Server XML Forum. Shailesh, Please mark the post as answered if it answers your question.

I do not know how you coded your functionality, but it seems that it could be done by having a template file with the <?XML version "1.0"... etc then when you have you XML file produced you issue an append in form say of exec xp_cmdshell 'XMLResult.xml >> XMLHeader.xml'Arthur My Blog