title: How do I import mm/dd/yyyy values in a file to a database field of format yyyy-mm-dd?
body: <p>I have a CSV file with date column in the following format <em>mm/dd/yyyy</em> (4/20/2012), and I  need to load this column into a database that has datetime column in <em>yyyy-mm-dd</em> (2012-04-20). </p>
  
  <p>I have used derived column transformation for this purpose and written and expression like  </p>
  
  <pre><code>(DT_WSTR)(SUBSTRING(ReceivedDateTime,1,4) + "-" + 
  SUBSTRING(ReceivedDateTime,5,2) + "-" + SUBSTRING(ReceivedDateTime,7,2)) 
  </code></pre>
  
  <p>Upon running my package, it's throwing the error <em><code>Unable to perform type cast</code></em>.</p>