• you could change the datatype at the destination table and then either impliciitly or explicitly convert the data in the data flow.