Biml and SSIS Frameworks - SQL Server Integration Services Design Patterns - page 559

,a.ApplicationName
,ap.StartDateTime
,DateDiff(ss,ap.StartDateTime,Coalesce(ap.EndDateTime,GetDate()))
As RunSeconds
,ap.Status
From log.SSISAppInstance ap
Join cfg.Applications a
On ap.ApplicationID = a.ApplicationID
Where a.ApplicationName
= Coalesce(@ApplicationName,a.ApplicationName)
Order by AppInstanceID desc
go
print 'Rpt.ReturnAppInstanceHeader stored procedure
created.'
print ''
Return to SSDT, right-click the Reports virtual folder in Solution Explorer, and
click Add New Report. If the welcome screen displays, then click the Next button. On
the Select the Data Source screen, select the shared data source named SSISConfig and
click the Next button. The Design the Query window displays next; add
rpt.ReturnAppInstanceHeader to the Query String textbox and click the Next
button. Select Tabular on the Select the Report Type page and click the Next button.
When the Design the Table page displays, multiselect all the columns listed in the
Available Fields listbox and click the Details button. The Report Wizard will appear as
shown in Figure A-20 .