title: Concatenate columns using derived column in ssis
body: <p>What I am trying to achieve is <code>Column 5</code>:</p>
  
  <pre><code>Column 1 Columns 2 Column 3 Column 4  Column 5
  A        B                  D         A|B|D
  </code></pre>
  
  <p>I used a derived column: </p>
  
  <pre><code>(DT_STR,50,1252)([A] + "|" + [B] + "|" + [C] + "|" + [D])
  </code></pre>
  
  <p>But I ended with:</p>
  
  <pre><code>Column 1 Columns 2 Column 3 Column 4  Column 5
  A        B                  D         A|B||D
  </code></pre>
  
  <p>I'm struggling to find the right solution.</p>