Issue with flat file schema

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Issue with flat file schema

Viewing 1 reply thread
  • Author
    Posts
    • June 17, 2010 at 5:02 AM #24989
      community-content

        Dear Sir,

        I have a flat file that contains 3 columns with the structure look like”NameAgeAddress”

        So I difined a flat file schema that has 3 elements “Name”, “Age” and “Address” by using  flat file wizard –> by relative positions.

        My flat file has two lines:
        Rober24Address
        Naris

        The  problem is line #2 doen’t have data for both Age and Address. So the schema is wrong generated.

         I am highly appreciate your help.

        Thank you.

         

         

      • June 17, 2010 at 8:44 AM #24994
        community-content

          Hi,

           

             Have you tried setting the attribute allow_early_termination to true in the annotation node of your flat file schema? If you can’t do it in Visual Studio, you’ll have to use a text editor to change that setting.

             See this blog for more information (even though it was written for version 2004, but I think it’s still applicable to 2009):

          http://blogs.msdn.com/b/skaufman/archive/2004/05/07/127899.aspx

           

              Daniel.

           

          • June 17, 2010 at 10:00 AM #24997
            community-content

              Dear  Daniel,

              Thank you so much for quick help. My current schema has already been set “allow_early_termination=”true”/. Unfortunately, it doesn’t work. Do you have any advice?

              Thank you

              • June 17, 2010 at 10:39 AM #24998
                community-content

                  Dear Daniel,

                  It is small update. My schema doesn’t receive an error like the following: ‘Unexpected data found while looking for: \r\n’ But data of lacking columns is terrible. I mean they get from the rest columns that have value.

                  Regards,

                  • June 17, 2010 at 12:38 PM #25000
                    community-content

                      Hi,

                       

                         If you are still getting that error, then check the following blog:

                      http://sandeepshewale.spaces.live.com/blog/cns!597AD44E67439214!212.entry

                       

                         If it’s a data issue, then correct it or have your partner (who sent this file) correct this issue.

                       

                         Daniel.

                       

                      • June 17, 2010 at 12:43 PM #25002
                        community-content

                          Hi,

                          I had a similar issue. I fixed the issue with a work around. Before the message the source schema in the pipeline, append the required number of empty spaces in the file for each line coming through. This can be done in a pipeline component.

                          Good luck.

                          Jyo

                           

                          • June 17, 2010 at 11:04 PM #25007
                            community-content

                              Hi Jyo,

                              You mean we should create a custom pipeline and  add it before deassembler, is it right?

                              Thank you 

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