how to convert date to mm/dd/yyyy in ssis?
2 Answers. Use a dataflow transformation Data conversion and choose DT_DATE as output type. The string in input (from your Excel file) will be convert to date object (if your table column is not typed as date).