Have you tried using the ISNUMERIC() function on the column you need to convert to a numeric data type?

While the ISNUMERIC() is not a "golden bullet", it may assist in identifying the relevant "faulty" values.

Remember, this error could be either from the INSERT / UPDATE itself, or from the relevant columns in your predicate(s) (either in the WHERE / HAVING / JOIN segments of your queries).