January 15, 2002 at 7:32 am
I am setting up an email to run when a package succeeds. This package accepts global variables. The destination of the email changes depending on what variables get pushed into the dts package. Can I get the destination of the email to change in the DTS Mail Task when the variable changes? Do I need to write an ActiveX scripting task instead? If so, how would I send email using VBScript?
Thanks-
Elizabeth Hague
Elizabeth
Elizabeth
January 15, 2002 at 8:10 am
Assuming that your global variable is formatted to reflect the proper email address you could use xp_sendmail and then set the @recipients variable in that procedure to equal your global variable. I have never done that but, it should work.
Hope this helps and let me know if you need further details.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 15, 2002 at 8:37 am
If you're using SQL Server 2000, you can use the Dynamic Properties task to perform this task.
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply