Validation warning in Data Flow Task in the SSIS
Your warning looks to stem from your output column(s) database mapping.  The 'TitleOfCourtesy' output column datatype/length needs to match whichever column in DimEmployee it is mapped to.

As far as the 4 records go, I'd see what the data is in the 5th one, since that seems to be where the error is.  Whenever I have your issue, it's always a datatype mismatch.