title: Load raw data to SQL Server
body: <p>There is data for Students table provided in a csv file.
  DDL to create the table :</p>
  <pre><code>
  Create Table students 
  (
      Student_Name nvarchar(50),
      S1 int,
      S2 int,
      S3 int
  );
  </code></pre>
  <p>Sample data in the file :</p>
  <pre><code>Student_Name,S1,S2,S3
  John Doe,92,90,98
  John,88,78,54
  </code></pre>
  <p>To load this I have built an insert into values code block for the entire file which looks something like this:</p>
  <pre><code>insert into Students values
  ('John Doe',92,90,98),
  ('John',88,78,549)
  
  </code></pre>
  <p>Another approach I tried is SQL server import tasks, with this all the data ended in the strings format. Had to cast/convert the data again into the <code>int</code> format for the <code>S1,S2 and S3</code> columns.</p>
  <p>Are there any ways other the these to load the data in the easiest way possible?</p>