1
Vote

Scrubs: SQL Reporting Services audit log mgmt SSIS log feed package

description

Scrubs: SQL Reporting Services audit log mgmt SSIS log feed package

Path field in RSExecutionLog.dbo.Reports isn't being updated if a folder name is changed on the report server. This causes the reports to be written to dbo.ExecutionLog as an unknown report with a ReportKey of -1.

Our solution was to modify the log feed SSIS package to remove the Lookup report Transformation step in the Reports data flow task and replace it with a Type 1 slowly changing dimension (ItemId/dbo.Reports.ReportId as the business key) later in the data flow.

comments