Removing an XML node within custom pipeline
Using Biztalk 2010
I have a large Biztalk application with lots of history. I am forced to do things a certain way because they have always been done that way.
I am creating an XML document from the database by using XML Explicit (must be done this way).
In Biztalk I am using a Receive Location of type SQL. When configuring this receive location it is mandatory to fill in "Document Root Element Name". This adds a node around my XML which then causes it to fail XSD validation (I cannot change the XSD as it is supplied by an outside vendor)
Problem: I need to remove the outermost XML node that the Receive location has added to my XML and I need to change it in my Custom Pipeline. (I can NOT use XSLT and I can NOT use a map) I must do this within my Custom Pipeline.
Your help would be appreciated.