SSRS : Need to run SSRS reports on sharepoint site using SSIS

Question

I have created few SSRS reports in SQL server 2012 with Visual Studio 2010 version.

And I have deployed them to one SharePoint Site.

I want to make this automated, so that data available in the reports are up to date.

So, now I would like to create SSIS package which will run periodically to get up to date data using integration services. I am very much new to SSIS. I have tried to look at different sites for this, but I am not getting an exact idea from where to start.

Can anyone please guide me on this? How can I create a WSDL file URL for the SharePoint report? Do I really need it if report is already made in SSRS or do I just want to run that?

Thank you.

Answer 1

Would SSRS caching solve your problem?

Otherwise, there's nothing SSIS specific to solving your problem. You will simply need to use the .NET library to visit the page with the appropriate parameters. Visit your report page and copy the full URL.

Inside a Script Task use that URL as part of the WebClient. You'll probably need to supply credentials with this. No need to deal with storing the output, you'll simply want to validate that you get a 200 message code

Answer 2

Can you clarify what you are trying to achieve? Do you want to automate the running of the Reporting Services reports? In that case you should look at Report Subscriptions.