Xml-Invalid character in text.Sp_xmlpreparedoc

• usha.neelkant

  Newbie

  Points: 1

  More actions

  February 1, 2008 at 10:02 am

  #182389

  Hi

  My source database is of collation :SQL_Latin1_General_CP1_c1_AS

  My destination database is of collation:Latin1_General_c1_AS

  I have an xml field of varchar(500) to be load into destination.All these it was working fine.Now i am getting an error

  "Xml parsing error-Invalid character in text"

  I cannot make any changes to source and also collation cannot be changed.Please help me

• SwePeso

  SSC-Dedicated

  Points: 39758

  More actions

  February 4, 2008 at 5:58 am

  #774706

  Are you using one of the reserved characters out of place?

  @ :

  ---

  N 56°04'39.16"
  E 12°55'05.25"