title: Date Format In SSIS Derived Column
body: <p>I have 2 questions, I have a text file with all my data, in the text file I have for example <code>Sply_DT</code> and <code>Imprt_DT</code>.</p>
  
  <p>For <code>Sply_Dt</code> I have to create <code>getdate()</code> and I have it formatted as <code>2012-10-25 12:04:16.09900000</code> using <code>(DT_DBTIMESTAMP)(DT_DBDATE)GETDATE()</code> but I want it formatted as <code>MM-DD-YY</code>.</p>
  
  <p>And for <code>Impt_DT</code>, it's in the <code>5/16/2011</code> format in dataviewer but when I placed it into a table it looks like <code>2011-05-16 00:00:00.000</code> and I want it in <code>MM-DD-YY</code> format.</p>