title: SSIS Derived column padding of leading zeroes
body: <p>I want to be able to add leading zeroes in following scenarios -</p>
  
  <ol>
  <li><p>I need leading zeroes before [ACCOUNT ID] if [ACCOUNT ID] &lt; 17 {For APPLICATION = RCC, SEC, HOGAN CIS}</p></li>
  <li><p>I need leading zeroes before [ACCOUNT ID] if ([ACCOUNT ID] + [ACCOUNT NUMBER]) &lt; 17 {For APPLICATION = CLN}</p></li>
  <li><p>I need leading zeroes before [CLIENT KEY] if ([CLIENT KEY] + [CLIENT ID]) &lt; 17 {For APPLICATION = ITF}</p></li>
  </ol>
  
  <p>I have the following expression defined in my derived column -</p>
  
  <pre><code> LTRIM(RTRIM(APPLICATION == "RCC" || APPLICATION == "SEC" ? APPLICATION + "|" + [ACCOUNT ID] : APPLICATION == "HOGAN CIS" ? (HOGAN_Hogan_Alpha_Product_Code == "DDA" ? "DDA" : "TDA") + "|" + [ACCOUNT ID] : APPLICATION == "ITF" ? APPLICATION + "|" + [CLIENT KEY] + [CLIENT ID] : APPLICATION == "CLN" ? APPLICATION + "|" + [ACCOUNT ID] + [ACCOUNT NUMBER] : APPLICATION + "|" + [ACCOUNT NUMBER]))
  </code></pre>