Validation Failed “All digits expected” Message

If you get a message such as:

Validation failed for EXPI “Harmonizing Tariff Code (HTS)”. 9999999999 is not a valid Harmonizing Tariff Code (HTS) value. All digits expected.

It could be that your source data is returning a value with trailing spaces. Once solution is to change the SQL to something like:

RTRIM(HarmonizingTariffCode) as HarmonizingTariffCode