title: How to convert MM/DD/YYYY HH:MM:SS.SSS text to a date in SSIS 2012
body: <p>I am coming from an Oracle background and cannot figure out how to convert a date string from a flat file (in <strong>MM/DD/YYYY HH:MM:SS.SSS</strong> format) to a date type in SSIS.</p>
  
  <p>An example of the date string is: <strong>10/9/2013 11:29:24.933</strong></p>
  
  <p>What date format should I use and how should I do it?</p>
  
  <p>Assume that both day and month won't have leading zeros, the hour is in 24 hour time, and I need to maintain the seconds' precision.</p>