I run a batch job which contains multiple BCPs. The syntax I use is :
bcp xxx_yyyy.dbo.table1 in f:\aaaaa\rm_bbbbb.txt -e err_bbbbb.txt -U "xxx_dbo" -P "xxx_dbo" -m 10 -b 1000 -c -t"|" -S "SERVER NAME" -o bcp_bbbbb.txt
bcp xxx_yyyy.dbo.table2 in f:\aaaaa\rm_ccccc.txt -e err_ccccc.txt -U "xxx_dbo" -P "xxx_dbo" -m 10 -b 1000 -c -t"|" -S "SERVER NAME" -o bcp_ccccc.txt
When the batch is executed by autosys the two BCPs execute one after the other. Due to some reason if the 1st BCP fails, the 2nd BCP is triggered and the failure of the BATCH job is not trapped. Is there any way I can capture the error from the first BCP and prevent the 2nd BCP from triggering and the entire BATCH job should abort?