SSIS Reporting Pack v1.1.1.0

Rating: No reviews yet
Downloads: 982
Change Set: 72959
Released: Sep 5, 2013
Updated: Sep 5, 2013 by jamiet
Dev status: Stable Help Icon

Downloads

Application SSIS Reporting Pack.msi
application, 876K, uploaded Sep 5, 2013 - 982 downloads

Release Notes

A call to
EXEC usp_ssiscatalog 
		@a				=	'exec'
	,	@exec_execution			=	0
	,	@exec_events			=	0
	,	@exec_errors			=	0
	,	@exec_warnings			=	0
	,	@exec_executable_stats	=	1

returns information about every executable in an execution, namely the [execution_path], [start_time], [end_time], [execution_duration] (milliseconds) and the executon result (success, failure etc...).
With this release we introduce a new column called [Gannt]. Quite simply this provides a Gannt-chart visualization indicating how long each executable executed for in relation to all the others.

This image, tho slightly reduced in size, illustrates the [Gannt] field

Click here to see a larger version of this image.
On the left we have the execution_path of each executable in a given execution and on the right we see how the combination of columns forms a view akin to a Gannt chart, thus visualizing the relative durations and start times of each executable.

Reviews for this release

No reviews yet for this release.