XML Source error message hexadecimal invalid character

• ppbird

  SSC Enthusiast

  Points: 140

  More actions

  March 3, 2015 at 11:10 pm

  #398106

  Hi all

  I am developing a SSIS package to add data from thousands of XML files to an existing SQL Server table.

  And I get the error message:

  The XML Source was unable to process the XML data. “
  ”hexadecimal value 0x01, is an invalid character.

  I know that these XML files are not well-formed (and hence not really an XML file).

  :doze:

  So, How to use the SSIS package to solve this problem without using the other editor?