Abstract
SSIS frameworks are the next logical step after SSIS design patterns because frameworks comprise many patterns. At a minimum, an SSIS framework should provide package execution control and monitoring. That sounds simple, but I assure you, it is not. Execution control requires a working knowledge of the Integration Services runtime API. Understanding the subtleties of tight—and loose—coupling is not merely helpful, it can make or ruin your day (or data integration solution).
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Andy Leonard
About this chapter
Cite this chapter
Leonard, A., Mitchell, T., Masson, M., Moss, J., Ufford, M. (2014). Evolution of an SSIS Framework. In: SQL Server Integration Services Design Patterns. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0082-7_21
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0082-7_21
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0083-4
Online ISBN: 978-1-4842-0082-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books