none
Some details are missing RRS feed

  • Question

  • Hi,

    After I've finished all these parts below,
    http://msdn.microsoft.com/en-us/library/aa577898%28v=bts.10%29.aspx

    is there any other steps/tutorials to further write the data into the database or where is the tutorial for the complete project including all steps to further go with this xsd file newly created? Simply, if I am already with such xsd file, what are the middle or next steps to go if I expect to finally put all the data in the flat file into the database table?


    Many Thanks & Best Regards, Hua Min



    Friday, October 5, 2012 3:10 AM

Answers

All replies

  • The link you are using is for converting flat file to xml . then after getting xml you can use WCF-SQL Adapter for send data.

    you can use storedprocedure or WCF-SQL Insert operation .

    Refer Article for Insert Operation

    Regards

    Mohit

    Friday, October 5, 2012 3:58 PM
  • Before going to WCF-Sql adapter, what should be done with xsd file?

    Many Thanks & Best Regards, Hua Min

    Monday, October 8, 2012 1:59 AM
  • Create Receive Pipeline for flatfile

    Use `Link.

    configure application for receive flatfile

    Monday, October 8, 2012 10:18 AM
  • Thanks. I need a tutorial to create pipelines from scratch for the flat file,

    Many Thanks & Best Regards, Hua Min

    Tuesday, October 9, 2012 1:57 AM
  • Hi HuaMin,

    You can refer to the following sample:

    FlatFileReceive (BizTalk Server Sample)

    http://msdn.microsoft.com/en-us/library/aa561381(v=bts.10).aspx

    The sample located in drive:\Program Files\Microsoft BizTalk Server 2009\SDK\Samples.

    Thanks.


    Leo Tang [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, October 9, 2012 8:50 AM
    Moderator
  • Sorry, I need one tutorial to do that from scratch instead of using any existing objects.

    Many Thanks & Best Regards, Hua Min


    Tuesday, October 9, 2012 8:54 AM
  • Hi HuaMin,

    You can follow the article below to create a new receive pipeline:

    How to Create a New Pipeline

    http://msdn.microsoft.com/en-us/library/aa578387(v=bts.10).aspx

    Then, check the following article to add a component to a pipeline:

    How to Add a Component to a Pipeline

    http://msdn.microsoft.com/en-us/library/aa560652(v=bts.10).aspx

    In your case, you can drag a "Flat file disassembler" from the toolbox into the Receive Pipeline designer, specify the schema you created previously as "Document schema". Then, you can deploy the project and use the pipeline in BizTalk administration console.

    Thanks.


    Leo Tang [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Wednesday, October 10, 2012 1:50 AM
    Moderator
  • Thanks. Should I use a Receive pipeline if the process is to have a flatfile as the input?

    Many Thanks & Best Regards, Hua Min

    Wednesday, October 10, 2012 2:00 AM
  • Hi HuaMin,

    Yes, Receive Pipeline operates on the incoming message(input) independent the message type. You can refer to the lifecycle of a message for more information:

    Lifecycle of a Message

    http://technet.microsoft.com/en-us/library/aa578560(v=bts.10).aspx

    Thanks.


    Leo Tang [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Wednesday, October 10, 2012 8:56 AM
    Moderator
  • Thanks a lot. Is there a complete tutorial to work with Xsd file/Pipe line/Adapter, by creating all of those from scratch, to load one Flat file in a specific format, to the database?

    Many Thanks & Best Regards, Hua Min

    Wednesday, October 10, 2012 9:10 AM
  • You will probably need to look at several tutorials...

    Parsing a flat file into XML using the flat file disassembler and receive pipeline.

    http://lwang00.wordpress.com/2007/10/15/import-flat-file-using-biztalk/

    http://msdn.microsoft.com/en-us/library/aa577613.aspx

    http://msdn.microsoft.com/en-us/library/aa578441.aspx

    Mapping from one XML format to another.

    http://technet.microsoft.com/en-us/library/ee251267(v=bts.10).aspx

    Persisting data to a database using the SQL adapter or WCF SQL adapter.

    http://social.msdn.microsoft.com/Forums/eu/biztalkgeneral/thread/5e054d03-31fc-4b2d-9b73-4c4ab433feae

    I can assist you with the first part; parsing a flat file into XML.  If you send me a sample flat file and a description of how you want it parsed I will provide a sample schema, pipeline and also include bindings for testing.  I'll also include a ReadMe.txt in the zip file to explain how to test it.

    You can send your sample flat file to my MSDN email at: ddowin@hotmail

     


    David Downing... If this answers your question, please Mark as the Answer. If this post is helpful, please vote as helpful.

    Wednesday, October 10, 2012 1:46 PM
  • Hi Hua Min,

    I agree with David, we currently do not have a tutorial include all from scratch which completely fit your requirement, you'll need to check several tutorials to achieve the goal. You can also request a sample from here.


    Leo Tang [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, October 11, 2012 1:50 AM
    Moderator
  • Many thanks all.
    David,
    I have created the Xsd file properly based on the given flat file. But I need some clear steps to go for further having Pipeline/Adapter for my project.

    Many Thanks & Best Regards, Hua Min

    Thursday, October 11, 2012 4:01 AM
  • Hi Hua Min,

    I'd suggest you check the following tutorial, it providers step-by-step information for building a complete project.

    EDI Interface Developer Tutorial

    http://msdn.microsoft.com/en-us/library/bb226541(v=bts.10).aspx

    If you still have problems, please give us detailed information about what you want to achieve, we may write a sample which covers receive data from flat-file and write the data to database, there would be some delay. Thanks.


    Leo Tang [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, October 11, 2012 8:13 AM
    Moderator
  • For my project, I expect to process one Flat file given in a specific format and further do data insert to the Database as per the given data in the Flat file. After I've created Xsd file for the Flat file properly, what should I further do based on such Xsd file?

    Many Thanks & Best Regards, Hua Min

    Thursday, October 11, 2012 8:26 AM
  • The main process to convert flat file into xml is done by Flat file disassembler. So make sure you use this disassembler in your pipeline. After the document is converted to xml format. Then you can easily insert it into database by using send ports with adapters like WCF-SQL.

    The following sample in SDK exactly addresses your issue.

    FlatFileReceive (BizTalk Server Sample)

    http://msdn.microsoft.com/en-us/library/aa561381(v=BTS.20).aspx

    Thursday, October 11, 2012 9:01 AM
  • I need detailed steps to work with disassembler.

    Many Thanks & Best Regards, Hua Min

    Thursday, October 11, 2012 9:24 AM
  • Within your BizTalk project, create a new receive pipeline by dragging the flat file disassembler from the toolbox into the receive pipeline disassembler stage.  In the properties window, set the "Document schema" to the flat file schema you want to disassemble (make sure the disassembler is highlighted so the properties are displayed).  Save the pipeline, build and deploy your solution.

    Create a receive port and receive location using the "BizTalk Server Administration Console".  Select the receive pipeline you deployed above in the receive location pipeline.

    Start your application and run your test.


    David Downing... If this answers your question, please Mark as the Answer. If this post is helpful, please vote as helpful.

    Thursday, October 11, 2012 3:15 PM
  • Many thanks.

    Is it fine that I choose the relevant Xsd file which I've built based on the given Flat file?

    How about other details of Validate/ResolveParty for the disassembler?


    Many Thanks & Best Regards, Hua Min



    Friday, October 12, 2012 2:12 AM
  • The flat file disassembler can be configured to validate the XML by simply setting the "Validate document structure" to "True" in the disassembler properties.  The validate stage of the pipeline can also be used for custom pipeline components.

    Party resolution is a much broader topic.  The following links may provide some insight:

    How to Configure the Party Resolution Pipeline Component

    http://msdn.microsoft.com/en-us/library/aa547385(v=bts.20).aspx 

    Developing and Configuring BizTalk Server EDI Solutions

    http://msdn.microsoft.com/en-us/library/bb226324(v=bts.10).aspx


    David Downing... If this answers your question, please Mark as the Answer. If this post is helpful, please vote as helpful.


    Friday, October 12, 2012 3:27 AM
  • Thanks a lot. Is it fine that I put the Xsd file name above? Must I have 'Resolve party' if I expect to push the data into a DB table? I think I can just leave it as it is for user security, right?


    Many Thanks & Best Regards, Hua Min


    Friday, October 12, 2012 3:30 AM
  • That's correct, you do not need to have a party resolver to insert into your DB table.  The BizTalk Host Instance account will need the appropriate access to the database however.

    David Downing... If this answers your question, please Mark as the Answer. If this post is helpful, please vote as helpful.

    Friday, October 12, 2012 3:04 PM
  • How about Decode & Validate parts?

    Many Thanks & Best Regards, Hua Min

    Monday, October 15, 2012 2:01 AM
  • You do not need the validation pipeline component, because you can enable validation using a setting in the Flat File Disassembler.  You only need a decoder if the flat file is received encoded.


    David Downing... If this answers your question, please Mark as the Answer. If this post is helpful, please vote as helpful.


    Monday, October 15, 2012 1:31 PM