SQL Server Performance

DTS Active x script needed....

Discussion in 'SQL Server DTS-Related Questions' started by raaj, Jan 9, 2008.

  1. raaj New Member

    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......
  2. martins New Member

    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...
  3. satya Moderator

Share This Page