title: Change Date format from yyyy-mm-dd to mm/dd/yyyy Derived Column
body: <p>I have a .txt flat file source. I am importing that into ssis to do some validation, manipulation to generate a .csv file. </p>
  
  <p>I am in need to convert the date format which is in <strong>yyyy-mm-dd</strong> to <strong>mm/dd/yyyy</strong> for certain date column. For example: DOB column has date 1984-03-16 needs to be converted to 03/16/1984. I am using derived column transformation but not able to figure it out. </p>
  
  <p>Any help is appriciated!</p>