title: Removing extra Tab row delimiter in ssis
body: <p>I am  loading data from table to flat file destination, where my flat file destination is Tab delimited. Actually my query is combination of 3 queries where I merged this 3 queries into into a single query by using temp table.  </p>
  
  <p>I have attached my output extract. Actually for data section 1, section 2, I have only 7 columns, where as for section 4 I have 10 columns.  </p>
  
  <p>Now, I want to remove the extra tabs from section 1 and section 2 data.   </p>
  
  <p>Am Attaching the required output also. how can I remove the extra tabs.  </p>
  
  <p><img src="https://i.stack.imgur.com/eEaki.jpg" alt="myoutfile">  </p>
  
  <p><img src="https://i.stack.imgur.com/pYLBZ.jpg" alt="required format"></p>