another issue just came up ....
i have come across some xml files that have the following:
-
-<Circuit Name="13B-10" Adrs="710" G="13B" Ofst="1" Micro="0" SvrID="0" ProcID="727842327" PrgIndx="641" PrgStp="2" Mode="7" A="37.91" StpAH="96.6" V="18.7" Tmp="32.0" StpT="152" RunTime="184" Comm="0" Tick="4095" Pwr="True" MainC="" ES="100" TLeft="392.0582" AccumAH="113.616" -Alarm="0" ProcStart="2/16/2010 9:17:34 PM" ProcEnd="12:00:00 AM" ProcInfo="" -ProcFree="12:00:00 AM" -TIA="0" TIV="0" TIT="0" Cyc="0" AT="0" CR="0" TCR="0">
-<Prg Name="269PMPG" Indx="641" AcummAH="False">
-<Stp ID="1" Cod="7" N2="34.1" T12="17"></Stp>
-<Stp ID="2" Cod="7" N2="40" T12="221"></Stp>
-<Stp ID="3" Cod="7" N2="34.1" T12="40.9"></Stp>
-<Stp ID="4" Cod="7" N2="25.5" T12="52.6"></Stp>
-<Ext>
-
-</Ext>
-</Prg>
-<UData></UData>
-</Circuit>
-</Circuits><Stp ID="2" Cod="7" N2="40" T12="221"></Stp>
-<Stp ID="3" Cod="7" N2="34.1" T12="40.9"></Stp>
-<Stp ID="4" Cod="7" N2="25.5" T12="52.6"></Stp>
-<Ext>
-
-</Ext>
-</Prg>
-<UData></UData>
-</Circuit>
-</Circuits>1" Cod="7" N2="40" T12="527.3"></Stp>
-<Ext>
-
-</Ext>
-</Prg>
-<UData></UData>
-</Circuit>
-</Circuits>ircuits>ts>s>ts>cuits>"></Stp>
-<Ext>
-
-</Ext>
-</Prg>
-<UData></UData>
-</Circuit>
-</Circuits>
don't mind the "-" as this what i did to post the text in the forum. The first element of -<Circuit> is fine as you can see but below you can see where the file has gotten corrupted and there is a bunch of -</Circuits> ... some are even incomplete within the < identifiers. I would like to truance the bulk load at the end of the good data. This is giving me a sql server first exception error.