A Simple, Custom, File-Based SSIS Framework
Andy Leonard, Kent Bradshaw · Apress eBooks · 2020
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 a larger enterprise.