If one of the BCP fail. Does it affect the rest of the process??

[Ali Alhussein]

Hi, I am wrote the following code in one store procedure called p_bcp_all.
and then scheduled it to run over night. what if the first two bcp were successful but the third one failed. Is the whole procedure going to fail? also what if the first one failed, is the rest of the code going to be executed have the bcp process going for the second and the third table?
thanks for your adivce

regards Ali

create procedure p_bcp_all as
Exec master..xp_cmdshell "bcp servername..tblone in d: blone.txt /fd:formatfile blone.fmt /servername /Usa /password/b250000 /a8000"

Exec master..xp_cmdshell "bcp servername..tbltwo in d: bltwo.txt /fd:formatfile bltwo.fmt /servername /Usa /password/b250000 /a8000"

Exec master..xp_cmdshell "bcp servername..tblthree in d: blone.txt /fd:formatfile blthree .fmt /servername /Usa /password/b250000 /a8000"
GO

[Mete]

Dear all,

I want to change default TCP connection port of SQL server 2000.

Does anybody know how to do this?

Thanks.

[MAK]

I answered this message already. if this has fire wall.

http://www.swynk.com/discuss_sql7/getmessage.asp?rootid=81653&id=81653




------------
Mete at 7/13/2002 10:52:20 AM


Dear all,

I want to change default TCP connection port of SQL server 2000.

Does anybody know how to do this?

Thanks.