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
 Transact-SQL (2000)
 BCP Batch count

Author  Topic 

chetan_zzz
Starting Member

2 Posts

Posted - 2006-08-09 : 02:34:41
Hi All,
I am using BCP with -b (Batch Size option).
Whenever I am importing a huge file & if error occurs; I dont wat to load entire file again instead I want to continue from the erroneous batch after correcting records.
Please let me know how can I achieve this.

-Rocky

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-08-09 : 16:08:43
chetan_zzz,

You can use the -F (First Row) option.

Ken
Go to Top of Page
   

- Advertisement -