title: Convert GETDATE() to YYYYMMDDhhmmss as derived column
body: <p>I'm trying to convert getdate to a string in YYYYMMDDHHmmss format without much luck. <strong>I need to do this in SSIS as a derived column.</strong> </p>
  
  <p>I've tried using Datepart, but it's not working.</p>
  
  <pre><code>Datepart("YYYY",(GETDATE())) &amp; datepart("MM",MONTH(GETDATE())) &amp; DATEPART("DD",(GETDATE())) &amp; DATEPART("HH",(GETDATE()) &amp; DATEPART("MM",(GETDATE())) &amp; DATEPART("SS",(GETDATE()))
  </code></pre>
  
  <p>Any clues what I'm doing wrong?</p>