title: Store line number of text file in table with bulk insert in tsql
body: <p>I have a text in the file like this :</p>
  
  <pre><code>In the name of God, the Mercy-giving, the Merciful! (1)
  Praise be to God, Lord of the Universe, (2)
  the Mercy-giving, the Merciful (3)
  Ruler on the Day for Repayment! (4)
  ...
  </code></pre>
  
  <p>then, a table with 2 field like this :</p>
  
  <pre><code>TextData Varchar(max) NoNullable
  Id       Int          NoNullable Identity(1,1) 
  </code></pre>
  
  <p>When Use this query :</p>
  
  <pre><code>bulk insert MyDb.dbo.translation 
     FROM 'd:\IRVING.Arb' 
     WITH 
        ( 
           ROWTERMINATOR ='\n', 
           codepage='1256' 
        )
  </code></pre>
  
  <p>I get <strong>(0 row(s) affected)</strong></p>
  
  <p>But, When I delete Id column from table , all line data copy it.</p>
  
  <p>How can I store line number of file in Id columns ?</p>