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 problem

Author  Topic 

deepabalasubramanian
Starting Member

21 Posts

Posted - 2001-10-02 : 10:29:44
i am using bcp while copying data from a flatfile to a table.
First time it worked fine.
The second time when i executed it I wanted to give a primary key violation error.
But it didn't show any error but insertion was not done.
Actually it showed error when i executed it in the Query Analyser.
But not when it executed by calling a stored procedure from VB

Should i specify some option in the bcp command.
Is it preferred to use bulk insert command instead of bcp.Which is faster.


   

- Advertisement -