Adding spaces to flat file

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Adding spaces to flat file

Viewing 1 reply thread
  • Author
    Posts
    • June 19, 2010 at 10:34 PM #25019
      community-content

        Dear Sir,

        I have a problem with flat file schema after using flat file schema wizard –> by relative positions.  The lenght of each line is different. So data after disassembling goes wrong.

        The structure of the file looks like:

        A12345678EDI
        B9871

        The lenght of line #1 is 12 but 5 for line #2.  I want to add new spaces to line #2 so that the lenght of this line is 12 before disassembling.

        Could you mind helping me the solution for this approach or you have another solution?

        Thank you so much for you help

      • June 23, 2010 at 5:19 AM #25038
        community-content

          Hi,

          You will have to create a pipeline component and use it in the Decode stage of the Receive pipeline.

          Its normal for Source System to miss row length but causes a big problem in BizTalk.

          • June 23, 2010 at 9:28 AM #25044
            community-content

              Dear Sir,

              Thank you so much for quick help.

              I have already created a decode custom pipeline. It is good. Unluckly, I got the error “No Disassemble stage components can recognize the data.  ”  when I used Flat file disassembler on my pipeline file. Do I need to create new Flat file disassembler too?

              Regards,

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