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.
| Author |
Topic |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2007-08-12 : 08:27:16
|
| i have a DTS that is activated by a JOB.in the DTs one of the steps calles a Stored Procudurein which i check some value, and the if th value incorrect i do :RAISEERROR("xxx",16,1) with logand in the dts if i get this step with failure it sends me to another direction in the dts (which mean onfailure it will make other things then the usuall course), and fro, there every thing continue ok.the only thing is that the job show failure status in the end, beacuse of the RAISEERROR i did, is there a way to RAISEERROR, withought making the job to show it has failed beacuse if the certin step?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
|
|
DTS and rais Error