So far the only way I can get this to work is to allow NULLs in the table, use the XMLUpload tool, then replace nulls with default values, then alter the table to not allow NULLs.

If anyone knows of a better way please pass it on!