• halifaxdal (7/18/2014)


    ScottPletcher (7/18/2014)


    I put a "\" (backslash) immediately followed by "n" in my previous comments, after the \r, but the site must remove it as some type of special editing character.

    Try setting the end terminator to:

    TERMINATOR="\r\~~n"

    but removing the ~~ first, so the \ and the n are directly next to each other.

    I tried your reply ( removing the ~~):

    <FIELD ID="12" xsi:type="CharTerm" TERMINATOR="\r\~~n" LENGTH="2">

    It still says

    Msg 9436, Level 16, State 48, Line 1

    XML parsing: line 16, character 9, end tag does not match start tag

    REMOVE THE ~~ FROM THE STRING.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.