title: SSIS column count from a flat file
body: <p>I'm trying to find a way to count my columns coming from a Flat File. Actually, all my columns are concatened in a signe cell, sepatared with a '|' ,<br>
  after various attempts, it seems that only a script task can handle this.
  Does anyone can help me upon that ? I've shamely no experience with script in C# ou VB.</p>
  
  <p>Thanks a lot
  Emmanuel</p>
  
  <p>To better understand, below is the output of what I want to achieve to. e.g a single cell containing all headers coming from a FF. The thing is, to get to this result, I appended manually in the previous step ( derived column) all column names each others in order to concatenate them with a '|' separator.
  Now , if my FF source layout changes, it won't work anymore, because of this manualy process. So I think I would have to use a script instead which basically returns my number of columns (header ) in a variable and will allow to remove the hard coded part in the derived column transfo for instance</p>