title: Convert string to DateTime in SSIS
body: <p>The data from source has string data type and sometime has invalid dates, empty column ('') I want to check whether it is valid date and convert string to date time. How can i do this in SSIS?</p>
  
  <p>My string value is already formatted as mm/dd/yyyy.</p>