BULK INSERT with identity (auto-increment) column

by

Add an id column to the csv file and leave it blank:

id,Name,Address
,name1,addr test 1
,name2,addr test 2

Remove KEEPIDENTITY keyword from query:

BULK INSERT Employee  FROM 'path\tempFile.csv ' 
WITH (FIRSTROW = 2,FIELDTERMINATOR = ',' , ROWTERMINATOR = '\n');

The id identity field will be auto-incremented.

If you assign values to the id field in the csv, they’ll be ignored unless you use the KEEPIDENTITY keyword, then they’ll be used instead of auto-increment.

More Related Contents:

  1. Bulk Insert Partially Quoted CSV File in SQL Server
  2. SQL Server Bulk insert of CSV file with inconsistent quotes
  3. How to write UTF-8 characters using bulk insert in SQL Server?
  4. Bulk insert with text qualifier in SQL Server
  5. How do you determine what SQL Tables have an identity column programmatically
  6. SQL Server – Auto-incrementation that allows UPDATE statements
  7. Cannot bulk load. Operating system error code 5 (Access is denied.)
  8. How to Bulk Insert from XLSX file extension?
  9. If condition in SQL Server 2008
  10. Comma separated results in SQL
  11. How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
  12. Which are more performant, CTE or temporary tables?
  13. Preferred Method of Storing Passwords In Database
  14. SQL WHERE.. IN clause multiple columns
  15. How do I copy SQL Azure database to my local development server?
  16. Can you call a webservice from TSQL code?
  17. How to safely use reserved SQL names?
  18. Comparing dates stored as varchar
  19. SQL Server: the maximum number of rows in table [closed]
  20. SSRS report definition is newer than Server
  21. Joining multiple tables returns NULL value
  22. “Prevent saving changes that require the table to be re-created” negative effects
  23. How to change column datatype in SQL Server database without losing data?
  24. Convert UTC Milliseconds to DATETIME in SQL server
  25. freeTDS not using its config
  26. @@ERROR and/or TRY – CATCH
  27. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  28. Bulk Insert Sql Server millions of record
  29. How to make a passthrough / passthru query editable?
  30. Tool for Scripting Table Data

Leave a Comment