See complete tooltip error message for Data Flow SSIS element in Visual Studio

The message will show in full form in the Error List window. Turn it on via View | Error List, or Ctrl–\ then Ctrl–E.
Make sure that Warnings is selected as shown here: