- This topic has 1 reply, 1 voice, and was last updated 9 years, 2 months ago by
.
-
Posts
-
-
I created a BizTalk solution that receives and XML file, sends it to a SQL adapter. The SQL adapter adds data from the XML file to a SQL database and returns the unique ID of the recently added table entry to BizTalk.
I need to update the original XML document (sent to the SQL adapter) with the ID returned from the SQL stored procedure but was told that the XML message cannot be changed after it enters the BizTalk message box.
I am very new to BizTalk and need help selecting the best solution for my problem. For example, can the XML message be copied by an orchestration and updated the the SQL generated ID, then placed in a folder where the calling application can pick it up. Or, do I have to call a Fetch routine (i.e.orchestration) immediately after the the SQL routine is completed? Or…please make a sugestion – thanks.
-
You will not have to write the file out to disk and re-consume it. Check out this link here: http://objectsharp.com/cs/blogs/matt/archive/2004/11/09/1009.aspx it gives you a few options when dealing with messages inside of your orchestration.
Is your ID element a repeatable node? If not then i would look into setting this element to be a distinguished field. That way once you have your response document you could then copy(use message assign shape) your request document and then update that field with the value from you SQL Response document.
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.