Storing Flat file data into Database

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Storing Flat file data into Database

Viewing 1 reply thread
  • Author
    Posts
    • November 28, 2006 at 8:08 AM #16565
      community-content

        Hi,
        I want to store the (EDI)flat file data into tables . I am using the SQL Adapter and Updategram to do this job. In the Orchestration I am using flat file Shema for mapping.
        Receive port's tranport is File , URI is input folder and pipe line is Default XML receive.
        When I drop the XML files in the input folder it is store in the database success fully.
        If I drop flat file in the input folder i am getting disassembler issue. Before I drop flat file,  I change the Receive port's URI to *.txt message type and piple line to Default PassThru.

        How can i store the flat file data into database with out creating another map for converting the flat file to XML?
        I am not sure how this process works.
        I am new to BizTalk.

        Thank you in advance.
        Siva

      • November 28, 2006 at 1:24 PM #16568
        community-content

          You need to create a custom pipeline and add the Flat File Disassembler. This is the component that converts the flat file into Xml, based on your flat file schema.

          • November 28, 2006 at 2:38 PM #16569
            community-content

              Thank you Greg.

              Siva

            • November 28, 2006 at 4:54 PM #16574
              community-content

                Hi,

                I created a custom receive piple line to convert the flat file to xml using the flat file schema.

                I am getting following error when I drop flat file in the input folder.

                There was a failure executing the receive pipeline:
                "SampleTDPO3.ReceiveTDPOFlat, SampleTDPO3, Version=1.0.0.0, Culture=neutral,
                PublicKeyToken=3e4eb9c872147ff3" Source: "Unknown " Receive Port:
                "rpTDPOSample3" URI: "C:\Excercise_Siva\SampleTDPO3\IN\*.txt" Reason: Failed
                to get pipeline: SampleTDPO3.ReceiveTDPOFlat, SampleTDPO3, Version=1.0.0.0,
                Culture=neutral, PublicKeyToken=3e4eb9c872147ff3. Please verify that the
                pipeline strong name is correct and that the pipeline assembly is in the GAC.

                In the Receive Pipe line properties there are 3 fileds for schema, Document
                Schema, Header Schmea and Trailer Schema. I set the Document Schema field to
                the Flat file Schema that I created and rest both I left as "NONe"

                Why do I get the above error?
                How to verify that the pipeline strong name is correct and that the pipeline assembly is in the GAC ? I have no idea about it.

                 

                Thank you in advance,

                Siva

                • November 28, 2006 at 5:28 PM #16576
                  community-content

                    The Biztalk assembly needs a strong name key, if you can deploy your assembly then it has a strong name key.

                    Did you restart the Biztalk Host Instance after deploying the assembly containing the pipeline.
                    It is possible that the Host instance has loaded a previous version of the assembly, and although the configuration specifies the SampleTDPO3.ReceiveTDPOFlat pipeline, it does not exists in the already loaded assembly.

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