BizTalk 2004: Orchestration question, string message -> xml message transformation

From: jsidhu (sidhu.j_at_gmail.com)
Date: 10/05/04

  • Next message: Ashish Udas: "Re: Add/Removing XMLDATA in StoredProcs for SQL Adapter" 
    Date: 5 Oct 2004 12:09:24 -0700

    I have a simple orchestration which uses a component method to run a
    Stored procedure and return some data. This data is actually a
    flat-file which I've already made the schema for. I want to parse this
    flat-file using the schema into an xml, and then do further processing
    on that xml. Im not able to clear this hurdle because:

    1) The message that is passed to my orchestration is a simple message
    which contains a uniqueID. The real message is in the DB which I have
    to get using my Stored Procedure call. I can successfuly make the call
    to my component, in a Expression box, and get the flat file back and
    assign that to a string Variable. Now this String Variable, i.e. the
    flat file, needs to be converted to the xml using the proper schema,
    which I have.

    2) If I had this flat file passed to me as the main message instead of
    the smalled message, I would simply use the flat-file disassembler to
    do the job and return me the xml version of the message.

    so you see, I am stuck at the point where I have a string variable
    that I need to turn into an xml message, whose schema I've already
    created.

    Any help in getting me across this roadblock would be appreciated.

    Thanks,

    JSidhu.

  • Next message: Ashish Udas: "Re: Add/Removing XMLDATA in StoredProcs for SQL Adapter"

    Relevant Pages

    • Re: SQL Send Adapter
      ... "Alan Smith" wrote: ... > 1 Set the field for the XML part of the SQL insert message to distinguished. ... >> I am clear on how to create the schema and the ports; ... >> on how to pass the input XML message to the stored procedure. ...
      (microsoft.public.biztalk.general)
    • Re: SQL Send Adapter
      ... I am trying to use this suggestion without success so far. ... Set the field for the XML part of the SQL insert message to distinguished. ... I am clear on how to create the schema and the ports; ... on how to pass the input XML message to the stored procedure. ...
      (microsoft.public.biztalk.general)
    • Re: SQL Send Adapter
      ... You can use an expression shape in the orchestration for this. ... Set the field for the XML part of the SQL insert message to distinguished. ... > I am clear on how to create the schema and the ports; ... > on how to pass the input XML message to the stored procedure. ...
      (microsoft.public.biztalk.general)
    • RE: wish to not receive a response
      ... Their is no SPROC, ... I am mapping my schema to the SQLService.xsd schema. ... > XML to SQL, and it was taking one of the element names in my bad XML and ... > In your case he thinks the stored procedure is 'spTest'. ...
      (microsoft.public.biztalk.general)
    • Re: how to return xml document from a web service
      ... what specific XML you expect. ... If you have a schema that defines what you expect, ... The second issue with this approach is that XML is not a string. ... >> methods from the wire transport. ...
      (microsoft.public.dotnet.framework.aspnet.webservices)