title: BULK INSERT Error: Incorrect syntax near '+'
body: <p>What is wrong with the following code?</p>
  
  <pre><code>BULK INSERT test
  FROM 'myfile_'+ CONVERT(VARCHAR(20), GETDATE(), 112) + '.TXT'
      WITH
      (FIRSTROW = 2,
       FIELDTERMINATOR = '~',
       ROWTERMINATOR = '\n')
  </code></pre>
  
  <p>Error Message:</p>
  
  <blockquote>
    <p>Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '+'.</p>
  </blockquote>