all groups > sql server dts > august 2006 >
You're in the

sql server dts

group:

SMTPMail Task


SMTPMail Task putrevu
8/14/2006 10:07:23 AM
sql server dts:
http://www.sqldev.net/dts/SMTPTask.htm - this tool is simply superb,
using which we can send mails with out using MAPI.

My question is..is there any option to dynamically set the properties
of MULTIPLE tasks at a time.

For one SMTPMailtask, using dynamic properties task we can set the
properties.
But in case of more than one smtptask...how can it be done
dynamically...

Thanks,
Rajashekar Putrevu
Re: SMTPMail Task DCochran NO[at]SPAM nospam.nospam
8/15/2006 10:15:46 AM
[quoted text, click to view]

You could create a variable that is in the scope of all the SMTPTasks
and then use the Expressions tab for the computed value.

HTH
Dave Cochran
AddThis Social Bookmark Button