title: Additional characters are coming during bulk insert
body: <p>I am trying to bulk insert the first row from a csv file into a table with only one column.
  But I am getting some extra characters('n++') in the begining like this:</p>
  
  <pre><code>n++First Column;Second Column;Third Column;Fourth Column;Fifth Columnm;Sixth Column
  </code></pre>
  
  <p>CSV file contents are like:</p>
  
  <pre><code>First Column;Second Column;Third Column;Fourth Column;Fifth Columnm;Sixth Column
  </code></pre>
  
  <p>You can find the test.csv file <a href="http://www.filefactory.com/file/b4ah0h3/n/test.csv/" rel="nofollow" title="here">here</a></p>
  
  <p>And this is the code I am using to get the first row data in a table</p>
  
  <pre><code>declare @importSQL nvarchar(2000)
  declare @tempstr varchar(max)
  declare @path varchar(100)  
  
  SET @path = 'D:\test.csv'    
  
  CREATE TABLE #tbl (line VARCHAR(max))
  
  SET @importSQL = 
  'BULK INSERT #tbl 
  FROM ''' + @path + ''' 
  WITH ( 
  LASTROW = 1,
  FIELDTERMINATOR = ''\n'',
  ROWTERMINATOR = ''\n''
  )' 
  
  EXEC sp_executesql @stmt=@importSQL 
  
  SET @tempstr = (SELECT TOP 1 RTRIM(REPLACE(Line, CHAR(9), ';')) FROM #tbl)
  
  print @tempstr
  drop table #tbl
  </code></pre>
  
  <p>Any idea where this extra 'n++' is coming from?</p>