Monday, January 30, 2017

Thursday, January 19, 2017

Bulk Report Generation using SSIS and SSRS 2008 R2

https://technet.microsoft.com/en-us/library/ff793463(v=sql.105).aspx

Execute SSRS Report from SSIS

https://www.mssqltips.com/sqlservertip/3475/execute-a-sql-server-reporting-services-report-from-integration-services-package/

Tuesday, January 17, 2017

Create a Data-Driven Subscription

https://msdn.microsoft.com/en-us/library/ms169673(v=sql.120).aspx

Report launcher to run SSRS report subscriptions on demand

https://www.mssqltips.com/sqlservertip/3078/report-launcher-to-run-ssrs-report-subscriptions-on-demand/

Analyze Report Execution and Usage Statistics in SQL Server Reporting Services

https://www.mssqltips.com/sqlservertip/1908/analyze-report-execution-and-usage-statistics-in-sql-server-reporting-services/

ExecutionLog2 View – Analyzing and Optimizing Reports

https://blogs.msdn.microsoft.com/robertbruckner/2009/01/06/executionlog2-view-analyzing-and-optimizing-reports/

Querying the Report Server Execution Log

http://www.sqlchick.com/entries/2011/2/6/querying-the-report-server-execution-log.html