I don't have any special characters in data.They are simple names like 'ran','san' and empnos are 1,2,3

How to check the data types in ssis.

i am just checking the datatypes in source and destination tables.