THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Davide Mauri

A place for my thoughts and experiences the Microsoft Data Platform

SSIS Dashboard v 0.6.1

Yesterday I’ve released the latest SSIS Dashboard update. There quite a lot of new features included that I found to very useful when you have a server full of packages and logs. Here the complete list: Highlighted the feature I think worth the most:

  • Updated Morris.js to v 0.5.1
  • Updated MetisMenu to v 1.1.1
  • Added information on "Child" Packages
  • Added more detail to the "Package Execution History" page. Also added an estimated end time / elapsed time for running packages, using a moving average of 7 steps.
  • Added navigation sidebar in the main page that shows available folders and projects
  • Added support for folders and project filtering
  • Changed configuration file in order to comply with Python/Flask standards
  • Cleaned Up code in order to follow Python best practices (still a lot to do :))

Have you had a chance to give it a try? What features you’d like to see added?

My plans for the next releases is to

  • Add a configuration page so that you can choose the maximum number of rows return (now set to 15) and the time interval you want to analyze (not set to 72 hours in the config file)
  • Use a EWMA instead of the simple Moving Average
  • Do a video to show how to install and use the Dashboard
  • Package everything in only one executable file / directory / VM (I want to be able to offer a xcopy deplyment “all-included”…not only the .py files)
  • Include additional information taken from [event_message_context], [executable_statistics], [execution_parameters_values]
  • Fix the layout for small / medium screens (smartphones / tablet)
  • Add historical / average elapsed time also for Child Packages and Executables
  • Include DataFlow informations

Once all those things will be do, version 1.0 will be ready

If you want to help, fork the code from Github:

https://github.com/yorek/ssis-dashboard

if you want to try it go here

http://ssis-dashboard.azurewebsites.net/

Published Friday, August 29, 2014 11:53 AM by Davide Mauri

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Roberto G. said:

Good Job Mauro!

August 31, 2014 9:53 AM
 

Mahesh said:

This only works with SSISDB right? What about packages stored and run from MSDB?

October 11, 2014 10:16 PM
 

Tash said:

This is fantastic :) - Having trouble as our server doesn't have access to internet so downloading pyODBC and Flask has been an issue.  Can't wait to see it all working.

September 12, 2016 7:38 PM

Leave a Comment

(required) 
(required) 
Submit

About Davide Mauri

Director of Software Development & Cloud Infrastructure @ Sensoria, an innovative smart garments and wearable company. After more than 15 year playing with the Microsoft Data Platform, with a specific focus on High Performance databases, Business Intelligence, Data Science and Data Architectures, he's now applying all his skills to IoT, defining architectures to crunch numbers, create nice user experiences and provide meaningful insights, all leveraging Microsoft Azure cloud. MVP on Data Platform since 2006 he has a very strong background development and love both the ER model and OO principles. He is also a fan of Agile Methodology and Automation, which he tries to apply everywhere he can, to make sure that "people think, machines do".

This Blog

Syndication

Privacy Statement