title: Need Help Performing Derived Column Split in SSIS
body: <p>So in my Source Table from Excel I have a Column called <code>real/min/max</code> that counts population and I want to split this into 3 columns called <code>ActualPop</code>, <code>MinPop</code>, <code>MaxPop</code>.</p>
  
  <p>So an example would be</p>
  
  <pre><code>real/min/max 
  
  33/1/50
  </code></pre>
  
  <p>And I would need this to populate in the new Columns as</p>
  
  <pre><code>ActualPop  
  
  33
  
  MinPop
  
  1
  
  MaxPop
  
  50
  </code></pre>
  
  <p>I tried the following Expressions:</p>
  
  <p>ActualPop: <code>TOKEN([real/min/max],"/",1)</code></p>
  
  <p>MinPop: <code>TOKEN([real/min/max],"/",2)</code></p>
  
  <p>MaxPop: <code>TOKEN([real/min/max],"/",3)</code></p>
  
  <p>The issue is when I try to do my mapping to the SQL destination, I get an error about the Data Types. The destination has <code>INT</code> data types mean while in the Derived Column Editor I see the Data Types are Unicode String. I have tried to use the Data Conversion but that still does not work.</p>