On publication error list name of column that has a data type mismatch

On publication when the dataflow fails due to a data type mismatch, the error does not list which column has the data type mismatch. It is extremely time consuming to go thru each and every column in a very wide table to determine which one(s) have the data type mismatch. Would like the error to include the column in question. Also would be very helpful to have a validation option in the dataflow to validate this type of error prior to publishing. The data profiling will run at a 1000 row sample set but just spins when switching the profiling to the entire data set. Sampling only 1000 rows doesn't always produce the correct data type.