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_5

5. A Simple, Custom, File-Based SSIS Framework

Andy Leonard¹  and Kent Bradshaw²

(1)

Farmville, VA, USA

(2)

Providence Forge, VA, USA

 

If you survey enterprises using SSIS for data integration/engineering, you will learn most enterprises do not use the SSIS catalog. Most enterprises execute SSIS from the file system. Why? Enterprises with a smaller number of SSIS packages outnumber enterprises with large numbers of SSIS packages. Executing a few dozen SSIS packages is different – really different – from managing the execution of thousands of SSIS packages. Don’t take my word for it; ask any data engineer managing ...