Ok, partial solution.

The field was truncating because the Source Data Connection for XL had the field defined as 50 char. I guess it did that by default because I didn't set it.

Still don't know why it's losing two records out of 37262.