I am using a Exectute sql task to collect an email from a table and pass it to a parameter inside a for each loop.
I get an error
An error occurred while assigning a value to variable "LeadEmail": "Single Row result set is specified, but no rows were returned.".
Here is part of my select statement that uses sql to collect one or more email addresses and uses it as a string that i have mapped to a variable called "LeadEmail" in my package.
then in my precedence constraint I am using expressions. I have a flag for sending emails. If the email flag is 1 then it's a valid customer and 0 is ignore. If we ignore then successfully sends the control flow (email does not get sent) and then when the email flag is set to 1 then it is supposed to send an email and attachment to the list of recipients.....
does any one have an idea why I'm getting this error message?
It works fine but it shows failures and I need to reflect a clean process