title: SSIS Derived Column Transformation if not blank
body: <p>i have added a Derived Column task that adds &quot; at the beginning of a field and &quot; at the end of a field but i only want to apply it if the field is not null/not blank and contains characters</p>
  <p>my expression is, this works and correctly ads &quot;&quot; to the field but i only want to apply if there is data in the field</p>
  <pre><code>&quot;\&quot;&quot; + fieldname + &quot;\&quot;&quot;
  </code></pre>
  <p>but i cant work out how to only apply where field is not blank
  i tried something like this but is did not work</p>
  <pre><code>ISNULL([fieldname]) == FALSE ? &quot;\&quot;&quot; + fieldname + &quot;\&quot;&quot; : &quot;&quot;
  </code></pre>