Error on importing a file to database

• yoothasak1

  SSChasing Mays

  Points: 604

  More actions

  September 24, 2009 at 8:37 pm

  #135937

  Dear All,

  I have problem with dat file which I have to import it into database by code below:

  the problem is: if there is a line which don't have close tag " the importing get error and any line is not import.

  so,how can I import the lines which are corrected I mean the line which has "" and ""? and delete the incorrect line if posible?

  Please help.

  /*my example dat file */

  Beginning of annotation phase.

  Beginning of the graphics drawing.

  Graphic count: 0.

  End of the graphics drawing.

  Beginning of the labeling.

  /*end my dat file*/

  /*my import code */

  DECLARE @xml XML

  SELECT @xml = BulkColumn

  FROM OPENROWSET

  (

  BULK '\\ServerName\Sharefolder\FileName.Dat', SINGLE_BLOB

  ) X

  INSERT INTO dbo.TestLog (Code,Time,Target,Machine,Elapsed)

  SELECT

  C.value('@code', 'varchar(50)') as [Code],

  C.value('@time', 'datetime') as [Time],

  C.value('@target', 'varchar(max)') as [Target],

  C.value('@machine', 'varchar(50)') as [Machine],

  C.value('@elapsed', 'varchar(50)') as [Elapsed]

  FROM @xml.nodes('/Msg') X(C)

  /* end my code */

• dmoldovan

  SSCertifiable

  Points: 6334

  More actions

  September 25, 2009 at 1:51 am

  #1058368

  Can you add to your process a step which checks that the input XML is well formed?