BCP aborts when constraints are not satisfied

[Shrenik Nanavati]

Hi all ,
I have a problem using BCP. The execution of BCP proccess stops whenever an error of constraint voilation occurs. What i want is that the BCP should log the errors and continue the execution.

The manuals states that the errors are logged into the file specified during bcp and proccess continues. Whereas the same thing is not happening here.

I am using SQL Server version 6.5

Please help me out with a solution as soon as possible.

Thanks
Shrenik Nanavati

[Gregory]

use /m option for BCP.

from Books online:
/m maxerrors
Is the maximum number of errors that can occur before the copy is canceled. Each row that cannot be rebuilt by bcp is ignored and counted as one error. If this option is not included, the default is 10.



------------
Shrenik Nanavati at 3/10/99 8:44:39 AM

Hi all ,
I have a problem using BCP. The execution of BCP proccess stops whenever an error of constraint voilation occurs. What i want is that the BCP should log the errors and continue the execution.

The manuals states that the errors are logged into the file specified during bcp and proccess continues. Whereas the same thing is not happening here.

I am using SQL Server version 6.5

Please help me out with a solution as soon as possible.

Thanks
Shrenik Nanavati