 <p>Since you have 4 columns including the primary key column, you have to provide data for all four columns. Hence the first one is <strong>IDENTITY</strong> column, you can provide any value for that column as this column value will not be used but ommitted.</p> <p>In your case if you provide data like it will work:</p> <pre><code>1 11 11 11 1 22 22 22 1 33 55 66 </code></pre> <p>I have checked this and found it works. If you don't have any option to alter the csv file then you can create a staging table without the identity column and perform the bulk insert operation. After that, you can move data from your staging to target table by performing INSERT INTO command. I hope this might solve your problem.</p>