SQL Bulk load truncating data
Hi Community,
I am trying to SQL Bulk Load with the Create Table option. When this runs it is erroring on string truncation. I do not understand how to use the Mapper with only one side as a seco...
Forum Discussion
Did you ever get an answer to this question? I have the same use case.
Tried. Just worked for me.
Just File Reader (File name specified) → XML parser (No changes)
Spooky, that sample works for me too it is just a redacted/cut down representation of the larger original. Maybe there were some newlines or tabs that were purged via cut/paste… Cant see anything invalid in the original, that still shows the “mixed content is not supported” error…
Had a closer look, in the original machine-generated xml the elements were indented with some kind of space characters and the parser failed. Changing these to tab characters and the parser worked fine… Just a bit confusing as the failing XML appears to be valid UTF-8 XML.
Thanks anyway,
MikeJust check if its unix or windows filetype.
I had parser issue in past where I was using windows file on linux snaplogic runtime.
