The error relates to truncation so your trying to insert CHAR(100) into CHAR(50) for example, find the maximum size of the data in the column detailed and then increase the size of this field in the DB.

Another one will be that the source is set to the default size of 50 but the field is actually 25 and needs to be changed in the connection manager or add in a data conversion task.