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

,[Status])
Values
(0
,0
,0
,'1/1/1900'
,'1/1/1900'
,'Unknown')
Set Identity_Insert [log].SSISPkgInstance OFF print '0
row for log.SSISPkgInstance added'
end
Else
print '0 row already exists for log.SSISPkgInstance'
print ''
Now that these event-generating Script tasks are in place, test-execute the Par-
ent.dtsx package and then observe the log.LogEvents table by executing the
following T-SQL in SSMS:
Select * From [log].SSISEvents
My results appear as shown in Figure A-18 .
Figure A-18 . SSIS framework events!
Viewing the log.SSISEvents table in SSMS is disappointing. The data is ac-
curate and SSMS is doing its job, but the user experience could be better for this type
of data. Fortunately, SQL Server 2014 ships with SQL Server Reporting Services,
which provides a better user experience! Let's look at building reports to display this
data.