title: Extract data to SQL Server table from Sharepoint list using C#
body: <p>I have to insert data into a SQL Server table. My source (Sharepoint) and destination (SQL Server), field names are different from source to destination. Also, I have 300 columns at destination and 350 columns in source. How to handle this and map the fields?</p>
  
  <p>I went through this code link but am getting an error on column mapping:
  <a href="https://stackoverflow.com/questions/36914555/using-a-console-app-to-extract-a-data-from-sharepoint-list">Using a Console App to Extract a data from sharepoint list</a></p>
  
  <p>I have built ssis component using above link. But am getting an error</p>
  
  <blockquote>
    <p>column mapping fields error</p>
  </blockquote>