Alternatively you could set the destination to redirect the row on error rather than have the package fail and then add a destination, perhaps another table,  for the failed rows so that you can examine them separately.