title: SSIS Transform -- Split one column into multiple columns
body: <p>I'm trying to find out how to split a column I have in a table and split it into three columns after the result is exported to a CSV file.</p>
  
  <p>For example, I have a field called fullpatientname. It is listed in the following text format:</p>
  
  <pre><code>Smith, John C
  </code></pre>
  
  <p>The expectation is to have it in three separate columns:</p>
  
  <pre><code>Smith
  John
  C
  </code></pre>
  
  <p>I'm quite sure I have to split this in a derived column, but I'm not sure how to proceed with that</p>