Don't edit the properties in the connection manager - I've rarely made alterations at that level and usually because SSIS has been very stupid (generally when importing from an Excel spreadsheet).

Read your input from the connection into a 'Data Conversion' task, where you can create a new field that is the result of a conversion of an input column.