mail task - Expression for the to address i.e. recepient
Hi, How is it possible to place an expression for the to address of the mail task? Thanks
November 21st, 2011 4:45am

Hi, yes It is possible to use an expression for send address, To address as well as subject line. For more refer this.. http://msdn.microsoft.com/en-us/library/ms142165.aspx Rajkumar
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2011 4:54am

Go to Expression: ToLine = Receipient's email address FromLine = Sender's email address Randy Aldrich Paulo MCTS(BizTalk 2010/2006,WCF NET4.0), MCPD | My Blog BizTalk Message Archiving - SQL and File
November 21st, 2011 4:55am

Go to Expression: ToLine = Receipient's email address FromLine = Sender's email address Randy Aldrich Paulo MCTS(BizTalk 2010/2006,WCF NET4.0), MCPD | My Blog BizTalk Message Archiving - SQL and File Yes, I am doing this already but I would like to have an expression for the address instead of hardcoding it. Is this possible? Thanks
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2011 5:08am

You can create a variable (SSIS-> variables) named EmailTo, use it in expression then either use dtsConfig (SSIS Configuration); go to SSIS -> Package Configurations or execute your package using DTExec (http://msdn.microsoft.com/en-us/library/ms162810.aspx) with parameters /Set \Package.Variables[User::EmailTo].Properties[Value];"sample@gmail.com" Randy Aldrich Paulo MCTS(BizTalk 2010/2006,WCF NET4.0), MCPD | My Blog BizTalk Message Archiving - SQL and File
November 21st, 2011 5:16am

Hi, Go to expressions in Send mail task. select ToLine Property(To address) and select a variable which can be configured dynamically. Rajkumar
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2011 5:23am

Hi, You can use the DB mail to send mail with the required from, to and options available. Check this link to get clear idea on sending mails in SSIS http://beyondrelational.com/blogs/sudeep/archive/2010/03/02/using-db-mail-in-ssis.aspxThanks Karthikeyan Anbarasan http://f5debug.net/
November 21st, 2011 5:33am

Also check this small tip on to make the email validation to check if the required things are available or not. http://beyondrelational.com/justlearned/posts/355/make-a-delayvalidation-true-in-send-mail-task-to-validate-file-at-the-end-of-ssis-package-execution-in-sql-server.aspxThanks Karthikeyan Anbarasan http://f5debug.net/
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2011 5:34am

You can create a variable (SSIS-> variables) named EmailTo, use it in expression then either use dtsConfig (SSIS Configuration); go to SSIS -> Package Configurations or execute your package using DTExec (http://msdn.microsoft.com/en-us/library/ms162810.aspx) with parameters /Set \Package.Variables[User::EmailTo].Properties[Value];"sample@gmail.com" Randy Aldrich Paulo MCTS(BizTalk 2010/2006,WCF NET4.0), MCPD | My Blog BizTalk Message Archiving - SQL and File In the mail section of the Send Mail Task, there is no place to add an expression. So I left it empty. I went to the expression of the task itself and in the ToLine added the variable which has the email address. But, the task expects an address in the To section under the Mail property of the task. What am I doing wrong please? Thanks
November 21st, 2011 5:36am

Hi, Since you have set Toline as an expression, at run time the address from the variable will be taken. Make sure you have set one address to the variable. And if you have done all this, and still getting some error, post what it is.Rajkumar
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2011 5:42am

Thank you all.
November 21st, 2011 6:57am

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

Other recent topics Other recent topics