How to assign Flat file schema to Envelope message

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How to assign Flat file schema to Envelope message

Viewing 1 reply thread
  • Author
    Posts
    • #24706

      Hi Sir,

      I get the issue when assign the message from Flat file  to Envelope message. Let me explain more details:

      I have a text file that needs to be inserted into database. So what I do are:

      1- Using Orchestration to  convert text file to xml schema:

      <Test>
        <Name>SMITH</Name>
        <Name>PAMELA</Name>
        ……………..

      </Test>

      2. Using envelope to debatch this this xml schema to multiple records

      My qestion is how can I assign message from step 1 to step 2 in order to debatch xml schema to multiple records.

      Thank you

       

    • #24707

      Hi,

       

         If you are inserting records from your flat file into a table in SQL database, you don’t need to go through the step of debatching into an XML schema for multiple records. Use the WCF-SQL adapter, define a schema representing the signature of your Stored procedure through the Generated Items wizard in Visual Studio and map your flat file schema to that new schema. You can look at this example explained in this blog:

      http://connectedthoughts.wordpress.com/2009/06/29/using-the-biztalk-wcf-sql-adapter-to-load-a-flat-file-into-a-sql-server-2008-table/

       

         Hope this helps,

         Daniel.

       

      • #24716

        Hi Daniel,

        Thank you so much for quick update. I wish I could do the same your guide. Our currect design is to de-batch multiple records from flat file into many single records and then each record will be passed to WCF for inserting to database. I must insert each data by passing it to WCF. I can not use WCF-SQL adapter.

        Thank you for your help.  

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.