© Andy Leonard, Kent Bradshaw 2020
A. Leonard, K. BradshawSQL Server Data Automation Through Frameworkshttps://doi.org/10.1007/978-1-4842-6213-9_7

7. Framework Logging

Andy Leonard1  and Kent Bradshaw2
(1)
Farmville, VA, USA
(2)
Providence Forge, VA, USA
 

In our journey to build a simple, custom, file-based SSIS framework, we have built a metadata database (named SSISDB), a test SSIS project, loaded some sample metadata (for the test SSIS project), created the execution engine (Parent.dtsx), and added instrumentation.

This chapter covers persisting instrumentation messages that are generated in the execution engine to the SSISConfig database.

Create a Log Schema

The information messages raised by the execution Parent.dtsx and displayed on the Progress/Execution ...

Get SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial