title: SSIS - cast a date to use in an expression
body: <p>I want to cast a date into ISO format, and use it as a string in an expression in SSIS.</p>
  
  <p>This is what I type in T-SQL</p>
  
  <pre><code>select convert(varchar(8), GetDate(), 112)
  </code></pre>
  
  <p>and this is what I get back</p>
  
  <pre><code>20100630
  </code></pre>
  
  <p>My goal - is to create an archive folder based on the date. I have the File System Task part of creating a folder sorted, I can do that ... I just need to be able to Cast the date to a string, so I can use that.</p>
  
  <p>Thanks in advance.</p>