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