ssis 2005 passing variable to ToLine
Posted on 2009-04-09
I am able to read an oracle table.
I can pass the result set to a for loop .
I can select each column in the for loop and diplay it in a script
My sad state or despair:
After my script to display a message box, I have a send email control flow it works just fine if I hard code the ToLine.
I can also use the message type and message source to pass in a variable for the message body. NO PROBLEM, the emails work with ToLine hard coded.
Here is the issue. I want to be able to send (reminder) emails to a variable number of users (changes month to month) in the ToLine of the Send Email task in ssis 2005. This will not work so far. It seems the ToLine does not except a variable.
My variable is User::strEmail. Please note this variable does have the email address because if I use it in the body of the message and hard code the ToLine it works!! I can see the email passed in as a vaiable in the BODY of the message for multiple messages sent to the same HARD CODED ToLine address. I want to set the ToLine to this value.
I have tried in my ssis control flow send email task ToLine:
I tried setting the Expression (in ssis Send Email Task) ToLine to dts.variables("strEmail").Value.ToString or User::strEmail. Using the expressions opton to set ToLine to a variable will not except it says evaluate to null.
Is it possible to set ToLine in the Send Email task to a passed in variable? Has any one got it to work? And naturally I may be doing something stupid, so forgive me if I am.