title: Delete some columns, re-arrange remaining columns and move processed files for multiple .csv files using SSIS 2008 R2
body: <p>Googled for some tips on how to crack this. But did not get any helpful hits. 
  Now, I wonder if I can achieve the same in SSIS or not.</p>
  
  <p><strong>There are multiple .csv files in a folder.</strong> What I am trying to achieve is to:</p>
  
  <ol>
  <li>open each .csv file (I would use a parameter as filenames' change)</li>
  <li>Delete some columns</li>
  <li>re-arrange the remaining columns in a particular order</li>
  <li>save the .csv file (without the Excel confirmation message box)</li>
  <li>Close the .csv file</li>
  <li>Move the processed file to another folder.</li>
  </ol>
  
  <p>and re-start the entire above process until all the .csv files in the folder are processed.</p>
  
  <p>Initially I thought I can use the For Each Loop Container and Execute process Task to achieve this. However, not able to find any resource as to how to achieve the above desired objective.</p>
  
  <p>Example:
  <strong>Header of every Source .csv file:</strong></p>
  
  <p><strong>CODE</strong> | <strong>NAME</strong> | <strong>Value 1</strong> | <strong>Value 2</strong> | <strong>Value 3</strong> | <strong>DATE</strong> | <strong>QTY</strong> | <strong>PRICE</strong> | <strong>VALUE_ADD</strong> | <strong>ZONE</strong></p>
  
  <p>I need to delete columns: NAME | VALUE_ADD | ZONE from each file and re-arrange the columns in the below order.</p>
  
  <p><em>Desired column order:</em></p>
  
  <p><strong>CODE</strong> | <strong>DATE</strong>| <strong>Value 1</strong> | <strong>Value 2</strong> | <strong>Value 3</strong> | <strong>PRICE</strong> | <strong>QTY</strong></p>
  
  <p>I know this is possible within SSIS. But am not able to figure it out. Thanks for your help in advance.</p>