Re: Biztalk Mesage Status

From: Matt Milner (matt.milner_at_m3technologypartners)
Date: 04/23/04 

Date: Fri, 23 Apr 2004 10:21:28 -0500

Receve the xml message
Have an orchestration that is subscribed (has a receive port for that
message type) to that message
In the orchestration map your xml to your flat file schema
Send the flat file (you can set a property on the port to make sure your
orchestration doesn't continue until the file is successfully sent.
Now create a port to SQL server and create the message to send.
Send a message to the SQL port.

This is probably the easiest way to accomplish what you are trying to do.

Matt

"Laloo" <anonymous@discussions.microsoft.com> wrote in message
news:415C0F2E-A9A8-48EA-9FA7-D4B56F8E3C57@microsoft.com...
> All
>
> I need a design help. I am sending a message through BTS 2004. It's work
is convert the input XML into a flat file. Once it is done and if the
conversion is successful, then I need to update a status field in my
application database with SUCCESS.
>
> I heard that I can write a web service which would listen for this message
in Tracking Database and if it is thru, then the web service can updates the
status.
>
> ALternate is once the sending/conversion of file is through, I can have a
SQL adapter by which I can achieve the same.
>
> My questions:
>
> 1. What should I do to implement approach 1.
>
> 2. Is approach 2 possible?
>
> Pls guide.
>
> Thanks in advance

Relevant Pages

  • Re: BAM Question
    ... On a receive port (not orchestration) i need to collect a few things ... I get this information out of the xml message of course. ... In the pivot table, drag measure into the area labeled "Drop Data ... In the Tracking Profile Editor, select the Receive port shape from your ...
    (microsoft.public.biztalk.general)
  • Binary message creation in BizTalk Server
    ... Setup a new orchestration and drop a rcv shape and port in there in order ... Iterate through each of the vendors in your inbound XML message ... - assign the FTP username and password to use in the construct message ...
    (microsoft.public.biztalk.general)
  • Re: XML file size when using mapping and orchestration
    ... We loaded the file as single records into an Oracle table as XML (covered ... the whole flat file into Xml using messaging) all with the same batch id. ... Then we pulled the records out of the table inside an Orchestration, ... Biztalk as a full message. ...
    (microsoft.public.biztalk.general)
  • Re: How to architect BizTalk calling a web service
    ... Now I'm getting an error that the send port failed to ... Request XML and a schema for the Response. ... orchestration, but now I'm wondering if this is right. ...
    (microsoft.public.biztalk.general)
  • Re: Infinite output messages for one input message
    ... I have another schema that produces the following xml: ... I have a map with MainIn as the source schema and MainOut as the destination ... I have a receive port tied to this map, so that when I drop a xml file ... I then have a very simple orchestration that receives MainOut.xml files ...
    (microsoft.public.biztalk.general)