title: Bulk Insert with filename parameter
body: <p>I need to load a couple of thousands of data files into SQL Server table.
  So I write a stored procedure that receives just one parameter - file name.
  But.. The following doesn't work.. The "compiler" complains on @FileName parameter.. It wants just plain string.. like 'file.txt'.
  Thanks in advance.</p>
  
  <p>Ilan.</p>
  
  <pre><code>BULK INSERT TblValues
  FROM @FileName
  WITH 
  (
  FIELDTERMINATOR =',',
  ROWTERMINATOR ='\n'
  )
  </code></pre>