title: How to convert Date Time format from 'YYYY-MM-DD' to 'MM/DD/YYYY HH:MM:SS AM'
body: <p>I have a .csv file source. I am importing that into ssis to do some changes manipulation to generate a .csv file of special format. Date is coming from .Csv file.</p>
  
  <p>I am in need to convert the date format which is in yyyy-mm-dd to 'MM/DD/YYYY HH:MM:SS AM' for certain date column. For example: Report entry column has date 2017-03-27 needs to be converted to 03/27/2017 HH:MM:SS AM. How do i do it?</p>