SSIS XML encoding error -


i below error on ssis xml source. can me resolve issue please.

[customer master [2]] error: customer master unable process xml data. invalid character in given encoding. line 55979, position 10.

after doing more research have discovered there "hidden" character. character non breaking space. non breaking space valid xml character per xml specification https://www.w3.org/tr/xml/#charsets. non breaking space has hex ascii value of xa0.

char       ::=      #x9 | #xa | #xd | [#x20-#xd7ff] | [#xe000-#xfffd] | [#x10000-#x10ffff]  /* unicode character, excluding surrogate blocks, fffe, , ffff. */ 


Comments

Popular posts from this blog

Ansible - ERROR! the field 'hosts' is required but was not set -

customize file_field button ruby on rails -

SoapUI on windows 10 - high DPI/4K scaling issue -