| |
NYCMuser
Posts: 1
Score: 0
Joined: 11/14/2006
Status: offline
|
I have a Visual Basic ActiveX Script built into my DTS package. On the completion of the sql task, I have it run the following code with the values I need in place of the lotusnotesservername,fromemai@domainl, and myemail@domain. The code executes successfully, but doesn't send me an email. Any thoughts? '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() Main = DTSTaskExecResult_Success DIM WshShell Set WshShell = CreateObject("WScript.Shell") WshShell.Exec("cmd /C bmail.exe -s lotusnotesservername -t myemail@domain -f fromemail@domain -h -a "& " The job ran successfully!"&" -b ") ''WshShell = Nothing End Function
|
|