SQL

[igor]

I need to copy data file into the table (SQL Server 6.5) using bcp.exe. My table has IDENTITY column, data file doesn't. When I run bcp, I get errors "Attempt to bulk-copy a NULL value into a Server column which does not accept NULL values". According to documentation it should work without any additional switches. I can create table without IDENTITY column, copy data, and add column; however, there are more than 3 mln records and time is the issue.
Please, if anyone knows something, help me.
Thank you in advance.