Date formats - if doesn't work

http://stackoverflow.com/questions/34025371/ssis-2012-date-formats-dmy-vs-mdy

Remember to use Conversion to convert string to dateformat - don't use derived column solely