Bcp! Bcp below, I am wrong, please help master, thank you pull the ball! F:\>;bcp suning. . EISS_TAB_ELEMENT out EISS_TAB_ELEMENT.dat -Usa -Psuningoa -Ssuning n Starting copy. . . Host-file bulk-copied to 1,000 rows successfully. 1760 rows copied. Clock Time (ms. ) : Total = 9 = 16,000 Avg (110.00 rows per sec. ) F:\>;isql -Usa P -Soaserver Rev. use suningoa 2>; go Rev. truncate table EISS_TAB_ELEMENT 2>; go Rev. quit F:\>;bcp suningoa. . EISS_TAB_ELEMENT in EISS_TAB_ELEMENT.dat -Usa P -Soaserver n Starting copy. . . 1000 rows sent to SQL Server. Server Message : OASERVER - Msg 2601, Level 14, State 1 : Attempt to insert duplicate key row in object 'EISS_TAB_ELEMENT' with unique ind Ex 'EISS_TAB_E_6511463341' Bcp copy in failed Bcp! Removed from the index! ! ! Bcp complete reconstruction. Bcp! Index of plots Bcp! For some time there bcp increase in the table to increase the field-e switches IDENTITY [ Closed window ]