title: Remove last 2 digits from column1 and append those 2 digits to column2
body: <p>I have 2 columns of string data type named column1 and column2. Both the columns contains data in the following way.  </p>
  
  <p>**</p>
  
  <pre><code>Column1             Column2  
  ABCD12              5678ABC  
  ABCD99              2341KFJ
  GDHF33              1233DFG
  </code></pre>
  
  <p>**  </p>
  
  <p>now i want to remove last 2 digits from column 1 and append it to Column2. And my data has to be in this way.  </p>
  
  <p>**</p>
  
  <pre><code>Column1             Column2  
  ABCD              12 5678ABC  
  ABCD              99 2341KFJ
  GDHF              33 1233DFG
  </code></pre>
  
  <p>**  </p>
  
  <p>how can this be done in SQL Server and SSIS.</p>