January 22, 2002 at 12:45 pm
I have a batch file that will execute multiple BCP statements to load tables with production data. My question is, what is the best way to verify the BCP command executed successfully when the batch file runs. It will run unsupervised and I want to be able to check a return code and if the return code is bad, send an email and stop processing other bcp commands. Something like a branch or goto. Any suggestions? Also I have two stored procedures I would want to execute after the bcp commands have successfully finished, what is the best way to do this. Sorry, I am an old DB2 person trying to get into SQLSERVER
William H. Hoover
Louisville, Ky
William H. Hoover
Louisville, Ky
sweeper_bill@yahoo.com
January 22, 2002 at 1:07 pm
January 24, 2002 at 4:08 pm
I think a combination of a sql job and dts packages will give you want you want.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply