title: SQL BULK INSERT FROM CSV From a Folder
body: <p>I have this SQL command which will be used in a stored procedure and will be scheduled:</p>
  
  <pre><code>BULK INSERT Test101.dbo.Test102
  FROM 'C:\Bulk\samp.csv'
  WITH
  (
      FIELDTERMINATOR = ',',
      ROWTERMINATOR = '\n'
  )
  </code></pre>
  
  <p>It works well but what I want to do is to process all the <code>.csv</code> files from a folder (let's say <code>Bulk</code> folder) automatically. I mean, the user doesn't have to define the exact location with filename instead the stored procedure will process all the <code>.CSV</code> file from that folder and ignore the other files if there were. </p>
  
  <p>Please help.</p>
  
  <p>Thank you.</p>