Database Reference
In-Depth Information
Reporting Execution Metrics
SQL Server Reporting Services (SSRS) allows us to create reports that display SSIS
framework metadata and metrics in a more user-friendly format. We can add visualiza-
tions to the reports that will assist in identifying the status of SSIS applications and
SSIS packages.
Open a new instance of SSDT-BI and create a new Report Server project named
PublicFrameworkReports_PackageDeployment_2014
. In Solution Ex-
plorer, right-click Shared Data Source and click Add New Data Source. When the
Shared Data Source Properties window displays, set the Name property to
SSISConfig
and click the Edit button to configure the connection to your instance of the
SSISConfig
database. When I configure the shared data source, it appears as shown
in
Figure A-19
.
Figure A-19
.
Configuring the SSISConfig shared data source
You're now ready to build reports! Let's begin by creating a report to display ap-
plication instance data.
Before we jump into report development, we will create supporting objects in the
SSISConfig
database.
Listing A-21
contains the T-SQL script required to build the
rpt
schema and the
rpt.ReturnAppInstanceHeader
stored procedure.
Listing A-21
.
Creating the rpt Schema and rpt.ReturnAppInstanceHeader Stored Pro-
cedure
Search WWH ::
Custom Search