dts and email

[ehague]

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

 

[aalmeida]

Can I get the destination of the email to change in the DTS Mail Task when the variable changes? It all depends on where the values is keept and how you are setting it up AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"