SSIS Catalog DB Dashboard

Hi, This is not so much a Data Story but a template for a dashboard for looking at your own SSIS activity. I use SSIS extensively with my job and over the years have used various tools to help ...

SSISDB_Dashboard v1.03 Blank.pbix2.6 MB

how to

Other

Technology

ADR

Regular Visitor

6 years ago

Hi,

Awesome Report !

How do I input todays date into the parameter so it is dynamic and always looks up to todays date ?

Currently what i am seeing is I have to every morning update the parameter to todays date.

Please advise if I am doing something wrong.

What would be even better if there is any documentation on the solution ?

Regards,

Andrew

stretcharm

Memorable Member

6 years ago

Thanks

The report works on a number of days of history to load.

Set the MaxDaysData and the report will always load the latest data.

The example report for the community page works on a single dataset as it's a fixed dataset.

The only documentation is on this thread on in the github page.

https://github.com/stretcharm/SSIS-DB-Dashboard

To use get the template and when it opens populate the parameters to point to your

SSIS db server, Agent Job Server, SSIS db name and the MaxDaysData.

As long as it's SSIS 2012 or later and you have permissions it should just start working.

Start with a small number of days in case there is too much data or the SSIS queries are a bit slow.

If you have more questions I check the forum every once in a while.