The destination table , having check constraints I assume, does the logical checks for you. In the dataflow you can redirect error rows to another table. From there you could run some a T-SQL script to do the checks you are looking for to identify the reason for the error. Note that there could be more than one reason (like more than one column is missing a value). So the total for the structure you presented could be more than the number of redirected rows.