'I'm having an issue with trying to figure out how to delete files in a folder location older than a certain number of days in this case lets say 10. I have looked far and wide online and most of the "solutions" that I find are hard to understand and do not give a complete picture of how to do it, they give about 80% and leave the 20% that are needed to make the solution work.'...
https://www.sqlservercentral.com/forums/topic/deleting-files-older-than-n-days-using-ssis
'In SQL Server 2008 R2, the Reporting Services execution log table is called dbo.ExecutionLogStorage (whereas in 2000 and 2005, it was called ExecutionLog). This table logs an entry each time the Report Server interacts with a report after it's been deployed to the Report Server.
Execution Log Views
Since Microsoft recommends against querying the Report Server tables directly, it provides 3 standard views in the ReportServer database.
- dbo.ExecutionLog: for backwards compatibility
- dbo.ExecutionLog2: for SQL Server 2008
- dbo.ExecutionLog3: for SQL Server 2008 R2 (same as ExecutionLog2, with 2 fields renamed: ReportPath is now ItemPath, and ReportAction is now ItemAction)'...
https://www.sqlchick.com/entries/2011/2/6/querying-the-report-server-execution-log.html