How to execute the SSRS reports in SSIS Package using C# or Subscription
Hi Guys, Hope you all are doing well. Right now I stuck into one issue and I want to know is there any way so that we can call/execute the SSRS reports in SSIS Package. Scenario: I want to execute 5 SSRS Reports based on the number of Days like( Current Date/7 Days/21 Days/30 Day...60 Days....etc.) and before executing these Reports I am executing the Stored Procedure in which I am passing the values for the dates and the calculation part is handled. right now I am executing these reports and SP's individually but I want to integrate all the above process in one SSIS package. So I want to know if there is any way we can call the Reports from SSIS Packages. Kindly help.