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_2

2. Automation with Stored Procedures

Andy Leonard¹  and Kent Bradshaw²

(1)

Farmville, VA, USA

(2)

Providence Forge, VA, USA

 

Now that we see all the pieces that need to be coordinated day in and day out for executing the processes defined in Chapter 1, let’s introduce the idea of controllers. A controller is the most basic element in our demonstration of the framework concept. The examples that follow demonstrate how controllers can make your job easier while also reducing the overhead that your operations staff must deal with.

A Daily Process Controller

For our purposes, a controller is a stored procedure that ...