It can be confusing to know which tool in the SSIS toolbox to use when trying to execute a PowerShell script from within SSIS.
The best task to use is an Execute Process Task. Under General you can give it a name and a description.
On the process section you fill in all the necessary details. Such as Executable, Arguments and Working Directory.
Once this is complete you can then execute your PowerShell script from within SSIS.
Many people complain about their reports taking a long time to load when they access them first thing in the day. This is due to the reporting server’s recycle time. What happens is SSRS regularly restarts the application domain after a specific time period. Upon first request to the report server after the application domain has been restarted, SSRS needs to load all the settings and this takes quite a long time.
The default recycle time for the application domain is 720 minutes. This can be increased to a more reasonable time, however this does still not solve the problem. The first request to the report server will still take a long time to process.
If you would like to increase the recycle time you can do this in the rsreportserver.config file. The file can be located in “C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer”
You can search for the below line of code in the config file and increase the time:
The better solution would be to schedule a PowerShell script that refreshes the report server twice a day. This will make the access to the report server for the first user fast. They will no longer have to wait long for the report to load.
There are two PowerShell scripts that you can use. The first script will access the report server:
$root = 'https://Hostname/reports/'
The second script will start up IE and open up a report that is deployed on the server. You can specify which report to open up.
v=$root = 'http://Hostname/reports/report/ReportNameToAccess'
$IE=new-object -com internetexplorer.application
You can schedule either of these scripts to run with Windows Task Scheduler.
Hope this helps you with speeding up the load time of the reports!