title: SSIS Derived Column (if then...else)
body: <p>is there a way of replicating the below expression in SSIS Derived Column?</p>
  
  <pre><code>SELECT CASE
             WHEN LEN(column1) &gt; 8
                 THEN
                     column1
                 ELSE
                     REPLICATE('0', 18 - LEN(column1)) + column1
             END AS column1
  FROM myTable
  </code></pre>
  
  <p>I want to pad the value of column1 with 0 if the lenght of the value is less than 8 character</p>