to convert flat file to xml

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › to convert flat file to xml

Viewing 1 reply thread
  • Author
    Posts
    • January 22, 2007 at 1:57 AM #17342
      community-content

        Hi,

        Please help me this; I have a text file which contains 1) Employee ID  2) Emplyee name 3) Job Band 4) Salary 5) Date. The input is in flat file which looks like this:–

        67899~kashmira~D~187787~2006-07-17

         Now i choose to use custom pipelines and make orchestration in such a way that it compares the

         Now i choose to use custom pipelines and make orchestration in such a way that it compares the

        job band = 'D'

        then salary = salary * 1000

        else terminate orchestration.

        I expect the output in xml while the input is a text file

         

        please treat this as urgent …

        thanks in advance..

         

      • January 22, 2007 at 2:47 AM #17345
        community-content

          You can easily Create the Schema for the input text file…child delimeter ~.

          U can use custom pipeline for Flat file disassembler.

          Inside Orchestration you need to get the  "D"value and "Salary" by Xpath.

          There is a terminate shape .You can use that.

          Its as per my understanding

          • January 22, 2007 at 3:17 AM #17346
            community-content

              Hi Nishil

              I have created watever you have written but could you please tell me the configurations of the logical and physical ports coz i guess that is creating a problem and my file is not reaching the destination.the orchestration is getting terminated and error msg is"the instance was terminated by the user".

              Please reply.

              Thanks in advance.

            • January 22, 2007 at 3:19 AM #17347
              community-content

                Hi

                Please also explain in detail regarding creating custom pipelines. I am new to biztalk..Please guide me.

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