My advice:
1) on destination table never use char or varchar. Instead use Unicode nvarchar or nchar
2) do not copy data directly from flat files source or excel file source to OLE DB destination and instead use 'Data Conversion' object in 'Data Flow' task of SSIS