title: Bulk Insert in SQL Server 2005?
body: <p>This is my SQL query for bulk insert</p>
  
  <pre><code>BULK
  INSERT userTable
  FROM 'c:\name\userTable.txt'
  WITH
  (
  FIELDTERMINATOR = ',',
  ROWTERMINATOR = '\n'
  )
  GO
  </code></pre>
  
  <p>It results in the following error</p>
  
  <blockquote>
    <p>sql Cannot bulk load because the file "C:\name\userTable.txt"
    could not be opened. Operating system error code 3(The system cannot
    find the path specified.)</p>
  </blockquote>