Hi all,
I'm working on a project that requires the entire incoming XML message be saved to a SQL 05 database. I brought in the message using a receive shape set for a XMLDocument type message, tried converting it to a string, adding it to the generated item set up for SQL, then sending it to a stored procedure for insert. But I receive a number of errors--attribute value is more than 256 characters, root element missing (which appears to happen when the mapping fails for some reason), stored procedure expected parameter 'foo' but it wasn't supplied, etc. I have working orchestrations that interact with the database currently in production and a large number of them utilize stored procedures in this fashion, but I've never had to insert the entire XML message into a table. It seems like it should be rather simple so I'm convinced I'm just missing something. Does anyone know of any good examples or resources for this scenario? Any thoughts would be greatly appreciated! Please let me know if more details would be helpful as well.
Thanks!
About the second thing I said, I am sorry I didn't finish the statement, I actually in the Message Assignment shap, send the value back from xmlDocumet to my source mesage, you can see it from my code.
About the seond thing, I send the value back from the xmldocument to my soure message. you can see it from my code.