I need to use bulk insert to populate a table. How do I get the DBMS to supply a primary key? When I try to execute the T-SQL command I get a primary key violation error as expected since the key is not incorporated in the datafile. I've been staring at the syntax, but don't see how to get a key assigned automatically. The code I am using is:

BULK INSERT DEPENDENT
    FROM 'E:\ICS 321\HW2\Dependent View\DEPENDENT_data.txt'
    WITH (FIELDTERMINATOR = ',',
    ROWTERMINATOR = '
');

Does your table have a defined primary key on it that you are populating? Is the primary key an identity column?

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

Ummm... I never import directly to the final table... too dangerous with the lousy data that may be out there. You may want to consider importing into a "staging table" and then do data validations, data cleansing, etc, prior to inserting anything into a production table.

--Jeff Moden