A colleague over the weekend sent a note out to the team requesting any kind of insight.  It turns out that he had a job fail because an instance of the T-SQL ISNUMERIC built-in function behaved in an unexpected way. According to BoL: “ISNUMERIC returns 1 when the input expression evaluates to a valid numeric [...]