title: SQL Server BCP insert additional columns
body: <p>My reuirement:</p>
  
  <p>Input File:</p>
  
  <p>1,abc,xyx</p>
  
  <p>2,def,mno</p>
  
  <p>3,ghi,suv</p>
  
  <p>DB Table Structure:</p>
  
  <p>Col1 char</p>
  
  <p>col2 char</p>
  
  <p>col3 char</p>
  
  <p>col4 char</p>
  
  <p>col5 char</p>
  
  <p>Data in Table after BCP:</p>
  
  <p>col1 col2 col3 col4 col5</p>
  
  <p>1    abc  xyz  ab    xy</p>
  
  <p>2    def  mno  de    mn</p>
  
  <p>3    ghi  suv  gh    su</p>
  
  <p>Basically the col4 and col5 are calculated values from col2 and col3 values.</p>
  
  <p>Does SQL Server BCP utility support such kind of operation? Any pointers will be appreciated.</p>
  
  <p>Cheers
  GT</p>