SSIS Calls SSRS Report with One Parameter and Then Emails
-
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.
-
Before we go down the SSIS path, I just want to verify that Data Driven Subscriptions are not an option for you, because it seems like that should be your first choice for this. Otherwise, you are going to be calling the Report Services web service from SSIS.
-
Rick, did consider the data-driven subscription, but we have Standard installed, so doesn't look like that will be an option. The version of SQL was not my call. This was installed way before I arrived here.
-
In general, I don't like calling web services (especially synchronous calls) from an SSIS box, because that ties the performance of the SSIS box to that of the client (the performance of this report). That said, if you proceed, you are going to want to call the Render method for your report and then email the results.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply