I try to load the .xls (NOT .xlsx) to XML but failed every time. This existing code has been in production for long time so I do not think it is the problem. The error message:
Invalid character in the given encoding. Line 1, position 1..
The source Uri:
file:///F:/Clientdata/ACC/Services/Transport/Ftp/In/Market/Decrypted/MassEnroll - 2011-03-22- ProvisionFood2.xls
Any idea what might go wrong? Sorry I cannot upload the test file since there are many sensitive information.