title: How to Map Input and Output Columns dynamically in SSIS?
body: <p>I Have to Upload Data in SQL Server from .dbf Files through SSIS.
  My Output Column is fixed but the input column is not fixed because the files come from the client and the client may have updated data by his own style. there may be some unused columns too or the input column name can be different from the output column.</p>
  <p>One idea I had in my mind was to map files input column with output column in SQL Database table and use only those column which is present in the row for file id.</p>
  <p>But I am not getting how to do that. Any idea?</p>
  <p><em>Table Example</em></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>FileID</th>
  <th>InputColumn</th>
  <th>OutputColumn</th>
  <th>Active</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>CustCd</td>
  <td>CustCode</td>
  <td>1</td>
  </tr>
  <tr>
  <td>1</td>
  <td>CName</td>
  <td>CustName</td>
  <td>1</td>
  </tr>
  <tr>
  <td>1</td>
  <td>Address</td>
  <td>CustAdd</td>
  <td>1</td>
  </tr>
  <tr>
  <td>2</td>
  <td>Cust_Code</td>
  <td>CustCode</td>
  <td>1</td>
  </tr>
  <tr>
  <td>2</td>
  <td>Customer Name</td>
  <td>CustName</td>
  <td>1</td>
  </tr>
  <tr>
  <td>2</td>
  <td>Location</td>
  <td>CustAdd</td>
  <td>1</td>
  </tr>
  </tbody>
  </table>
  </div>