title: SSIS expression: convert date to string
body: <p>I'm new to SSIS and I'm trying to convert a GetDate() to string "DD-MM-YYYY".  This is the expression I've built so far:</p>
  
  <pre><code>(DT_WSTR, 8)  DAY( GETDATE()) + "-" + (DT_WSTR, 8)  (MONTH(GETDATE()) - 1) + "-" + (DT_WSTR, 8) YEAR(GETDATE())
  </code></pre>
  
  <p>The problem I've got is Month() converts the Month "23-4-2013" to a single character when I want it in Double character, same as day.  How do i make it into a double character no matter what month it is?</p>