This is what fixed the problem for me:

On the ADO.NET source editor, change "error" property of string columns to "Redirect row". Hit Ok to close the editor, save the package...

I have already tried a data viewer on the link between ADO NET and the next transformation, all the char/varchar columns were blank in the data viewer.