Hello guys, I am new to using sql server 200 DTS...... can anyone send me some sample active x script which sends mail if my previous task (execute process task- in my case) runs successfully saying 'success' else saying 'failure'... i.e. I am running a batch file in execute process task.... if it runs successfull i want a mail to be sended to some email id saying it is success... if it is failed i want to send email to another id saying it is failure... this i want to do it in the active x script only and not in send mail task......
Rather use a sql script to send mail. There are many examples on the net, so there should be no problem when searching. You can then run the script in DTS...