Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Bulk insert

Author  Topic 

bala
Starting Member

2 Posts

Posted - 2001-07-27 : 02:29:59
I want to insert the records into a table (which has primary key) using the BULK INSERT statement. I try to insert the data from a text file which has 100 records. the primary key violation occured at 50th record and the Bulk insert statements terminated and igonre all other records.But I want to continue the updation of all other record without any abnormal termination.
   

- Advertisement -