SSIS Error - The value cannot be converted because of a potential loss of data

Error

[OLE DB Source [167]] Error: There was an error with OLE DB Source.Outputs[OLE DB Source Output].Columns[MyColumn] on OLE DB Source.Outputs[OLE DB Source Output]. The column status returned was: "The value could not be converted because of a potential loss of data.".

Solution

Go into the source component then right clicking on it and choose "Show Advanced editor..."

From the Advance Editor select Input and Output Properties

Expand the OLE DB Source Output
Then expand the Output Columns
Select the column generating the error

O the properties section, scroll to the Length Data Type Property and increase the value to  something like 255.