Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How to assign Flat file schema to Envelope message
- This topic has 6 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
May 17, 2010 at 6:02 AM #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
-
May 17, 2010 at 9:08 AM #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:
Hope this helps,
Daniel.
-
May 17, 2010 at 9:25 PM #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.
-
May 18, 2010 at 8:05 AM #24720
Hi,
Check out the following blog by Stephen Thomas on how to do message debatching using a receive pipeline in an orchestration:
Daniel.
-
May 18, 2010 at 9:20 PM #24728
You can debatch the flat file in the Flat File Disassembler when you first receive the text message.
This is done by the way you specify your flat file schema.
http://geekswithblogs.net/benny/archive/2006/02/05/68249.aspxThis is the most efficient way of debatching.
Debatching and inserting single records into a database is the most inefficient of processes, so you will need every performance gain you can get. In a recent project I refactored a debatching application to insert multiple records at a time, elapsed time was reduced from 56 hours to 40 minutes-
May 20, 2010 at 3:11 AM #24757
Hi Sir,
Because current design requires Biztalk consuming WCF service. On WCF service, I implement one function to insert single DTO to database. So If I insert multiple records a time, I must design WCF again. I think should I use OpenXML to insert muntiple records?
Thank you so much
-
May 20, 2010 at 4:08 AM #24758
Rather than OpenXML you should check out XQuery functionality: http://articles.techrepublic.com.com/5100-10878_11-6140404.html
-
-
-
-
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.