title: Split a single column of data with comma delimiters into multiple columns in SSIS
body: <p>I have a table in SQL Server with 3 columns, one of which is a data column containing rows of concatenated columns delimited by commas. The first row is also the header row of the new table I want to create. so basically I want to turn this.</p>
  
  <pre><code>Data      | ID | Source 
  ====================
  a,b,c,d,e | 1  | a.csv
  
  f,g,h,i,j | 2  | b.csv
  </code></pre>
  
  <p>into</p>
  
  <pre><code>a | b | c | d | e
  =================
  f | g | h | i | j
  </code></pre>
  
  <p>Using SSIS, The only way i could think of doing it is using a dump into a text file of the data column and then re-read it as an flat file source, but I'd rather avoid creating extra unnecessary files</p>
  
  <p>EDIT: Sorry Im using SSIS 2008</p>