delimited file to SQL

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › delimited file to SQL

Viewing 1 reply thread
  • Author
    Posts
    • February 9, 2006 at 9:13 PM #12869
      community-content

        I assume you have a flat file schema like this

        [code:1:4aa4a0b248]root – delimited PostFix 0x0D 0x0A
        record – delimited Infix 0x0D 0x0A tag = @ occurs = 1 – unbounded
        blank
        Name
        Number[/code:1:4aa4a0b248]
        You should be able to add a comments record
        [code:1:4aa4a0b248]root – delimited PostFix 0x0D 0x0A
        comments tag = // occurs = 0 – unbounded
        text
        record – delimited Infix 0x0D 0x0A tag = @ occurs = 1 – unbounded
        blank
        Name
        Number[/code:1:4aa4a0b248]

        And then ignore the comment records in a map

      • February 9, 2006 at 10:09 PM #12870
        community-content

          [b:e7dd2a70fb]Errata:[/b:e7dd2a70fb]
          If you wish to handle files with or without comments you will need something like this:

          [code:1:e7dd2a70fb]
          root – delimited PostFix 0x0D 0x0A
          <choice occurs = 1 – unbounded>
          comments tag = // occurs = 0 – unbounded
          text
          record – delimited Infix 0x0D 0x0A tag = @ occurs = 1 – unbounded
          blank
          Name
          Number [/code:1:e7dd2a70fb]

          this should handle comment lines before, between and after the records

          • February 9, 2006 at 2:45 PM #12871
            community-content

              I have a text file delimited in the following format

              @
              harish
              10
              @
              sumitha
              8

              I was able to transfer these datas to SQL.

              But when the file changed (two lines with // in the first)

              //test
              //
              @
              harish
              10
              @
              sumitha
              8

              My projet did not work .
              What can i do to ignore the first two lines

              //test
              //

              can anybody help me?
              Thanks in advance

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