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.