I have tried the orchestration method, here is what I have done in my orchestration:
I have my receive message that I pass to a constructor, I do a Transform with nothing in it, then I do a Assign where I set a variable (XMLDocument type) to my receive message. I also set the distinguished field of my SQL Request schema, (inputXML) to the innerXML of the xmlDoc variable i set in the previous line.
Ok everything seems to make sense… but when I run it… I get an error “Could not find stored procedure ‘header'” Which is an element of my xml document
So I am guessing that its messing up the message going into SQL some how, but I don’t understand why.