title: Import Multiple CSV Files to SQL Server from a Folder
body: <p>I have a folder called <strong><em>"Dump."</em></strong>  This folder consists of various .CSV Files.
  The folder Location is <strong><em>'C:\Dump'</em></strong></p>
  
  <p>I want to Import the contents of these files into SQL Server. 
  I want the rough code along with proper comments so that I understand it. </p>
  
  <p>I have tried a few codes that I found on the Net. But they haven't quite worked out for me for some strange reason. </p>
  
  <hr>
  
  <p>The steps I would like to have are</p>
  
  <p><strong>Step 1:</strong> Copy all the File Names in the folder to a Table</p>
  
  <p><strong>Step 2:</strong> Iterate through the table and copy the data from the files using Bulk Insert.</p>
  
  <hr>
  
  <p>Someone do please help me out on this one. Thanks a lot in advance :)</p>