SSIS convert date in mmddyyyy format to date format using SSIS expression
You have to use substring to get the parts needed for year monh and so on
(DT_DATE)(SUBSTRING(yourcolumn,5,4) + &quot;-&quot; + SUBSTRING(yourcolumn,1,2) + &quot;-&quot; + SUBSTRING(yourcolumn,3,2))