[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.
