delimited file to SQL

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

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