Page 1 of 1

How to send EMAIL from Data Stage

Posted: Wed Apr 26, 2006 7:40 am
by abha.kalra
Hi
i m using notification activity to send email from data stage .
while doing this
i m giving in notification TAB
SMTP server name as our server name, and all the other values listed there.
But i m not able to get the output . my job is getting aborted and the warning message is :-

EMAIL..JobControl (DSSendMail): Error when executing command: C:\Ascential\DataStage\Projects\myproject\sendmail_EMAIL.bat
*** Output from command was: ***
SMTPMail Looking up server...
SMTPMail Opening connection to <my server name>...
SMTPMail Unknown failure!
SMTPMail Error in trying to connect
SMTPMail Network error 10060

Please check any paths in the following command file are correct, and if necessary adjust the 'dssendmail_template.txt' file in the project directory.

Contents of command file:
C:\Ascential\DataStage\Engine\bin\dssmtpmail.exe -file sendmail_EMAIL_file.tmp

can u please help me out in this. do i need to do any other settings.

Posted: Wed Apr 26, 2006 7:45 am
by DSguru2B
Looks like you have entered the wrong server name where ever the SMTP batch resides.

Posted: Wed Apr 26, 2006 7:57 am
by sb_akarmarkar
Hi,

Looks like you modify dssendmail_template.txt file.

Copy dssendmail_template.txt from template to project->project_name folder dont change anything in file dssendmail_template.txt . It will work..

Thanks,
Anupam
akarmarkar@smart-bridge.co.in