Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: ejonesThen you will have to find some header and footer for the file that will work. Every idea I've been thinking of defines it as a space and a space won't work for the same reasons you've shown above. Can you make the start and end record comment lines and put some comment there instead of nothing?
I believe you've found a limitation of this node and I personally agree that this should be improved in a new version. The challenge there is that you are attempting to use the Output XML node to create a file that is not actually an XML document. According to the definition an XML document must have a start tag and an end tag for the whole document. I'd personally like to see this rule in the official definition of an XML document relaxed.
Maybe if you told us more about what you are needing we might find another solution and also might provide more reasons to relax that rule on this node. Have you tried to use any of the other output nodes like the Output Delimited or Output Fixed nodes? And what stops them from working for you?