I have a few different orchestrations that execute a query and return rows with the same columns. I run these sequentially at night. I would like for the results of the query to be written as xml to a file. I have this working with an Execute Query -> Write XML -> Put File. The issue is, each orchestration will append the full xml to the file. I woudl liek each orchestration to write just teh <rows> data and not the xml a level above that. So after all orchestrations run, They have appended their rows to the file and I have 1 XML document. Any thoughts?
This topic has been locked.
2 replies Latest Post - 2013-09-20T12:55:03Z by sunilsure
Pinned topic Write XML file
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-12-28T05:45:37Z at 2010-12-28T05:45:37Z by SystemAdmin
SystemAdmin 110000D4XK1250 PostsACCEPTED ANSWER
No need to overcomplicate this2010-12-28T05:45:37Z in response to SystemAdminYou don't need the write XML, that takes an XML structure and turns it into a string. You just write the file out and point at the XML schema that has your structure.
Scheduled Job -> Execute Query (rows) -> Put File (rows) ->Log Success
You may have to define the row structure as an XML Schema for the Put File, but that's not too difficult.
You can specify whether to replace or append when you PUT.