SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory

© 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 Leonard¹  and Kent Bradshaw²

(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 ...