title: How can I convert string (YYMMDD) to datetime using derived column transformation?
body: <p>I have an input text file, which consists of few columns namely <code>TransactionID</code>, <code>receiveddt</code>, <code>description</code> etc. The <code>recieveddt</code> column has date value in the following format <strong><code>120419</code> <code>(yymmdd)</code></strong>. I would like to load the .txt input file into a database but the destination column <code>recieveddt</code> is of data type <code>DateTime</code>. I used the derived column transformation  to convert the incoming receiveddt column value to datetime as shown below</p>
  
  <pre><code>Derived Column Name  Derived Column     Expression            Data Type 
  -------------------  -----------------  --------------------  ---------
  receiveddate         replace reciveddt  (DT_DATE)[reciveddt]  datetime 
  </code></pre>
  
  <p>I tried different combinations but I keep gettings errors while attempting to perform a type cast.</p>
  
  <p>How can I convert string (YYMMDD) to datetime using derived column transformation?</p>