Sending Email
<html> I have a table with a list of email address. I want to send email to all the receipients, at one shot, using script task. I don't want to send an email one by one. I want to use script task because the message is a formatted HTML. How to do it. Thanks. </html>NSG12
March 29th, 2011 4:36pm

You could use the SmtpClient class: http://msdn.microsoft.com/en-us/library/system.net.mail.smtpclient.aspx Also see the Related Topics part on the left side. For example: http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/2bb3d10b-9f1d-446f-8db0-b7f47510a7c9 Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
March 29th, 2011 5:06pm

Thank you.NSG12
March 29th, 2011 5:42pm

you can also check Sudeep's blog also.. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2011 3:43am

Another option you can try is to get the addresses delimeted by semi-colon ';' and assign in the to, cc or bcc property of send mail task 1. Create an SP in the database that reads a column and assign the value to a string delimeted by semi-colon. A good sample of this kind is at http://databases.aspfaq.com/general/how-do-i-convert-columns-of-values-into-a-single-list.html 2. Add an execute sql task. Call the SP created above and assign the return value to a variable 3. Add a send email taks and sets is To property to the value in the variable asssined in step 2 Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
March 30th, 2011 4:25am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics