title: Removing leading zeros in SSIS
body: <p>I process data from a legacy system with SSIS before importing data into a SQL Server 2008 db.
  A currency field is so formatted:</p>
  
  <pre><code>000000xxx.xx
  </code></pre>
  
  <p>I need to remove the leading zeros. Note that the actual currency value has not a fixed number of digit. So, for instance,  it could be xxxxx.xx or x.xx or xxxxxxxxxxx.xx</p>
  
  <p>I found this <a href="https://stackoverflow.com/questions/2457603/algorithms-to-trim-leading-zeroes-from-a-sql-field">answer</a>, but the derived column tool display only limited string functions, like the Access formula wizard.</p>
  
  <p>So my question:</p>
  
  <ul>
  <li>how may I use PATINDEX in the DTS derived column tool</li>
  <li>otherwise, how may I remove leading zeros from input column</li>
  </ul>