Sorry if this is the wrong section.
I have a report that I have created that contains one parameter called AgentEmail.
This report generates a list of customers which our support crew are going to call, however, each customer is assigned to a certain support agent by using the agent's email. The support person's email address is part of the report, which is why there's a parameter called AgentEmail.
I want to create a SSIS package where calls the report, fills in the AgentEmail parameter, and then emails the agent with his report with his list of customers.
Hope my explanation was clear.
I've searched and searched, but really haven't found anything that helped. I do find some results were they say to use the ForEachLoop, but directions are terrible.
Thanks for any help provided.