Advertisement

Evolution of an SSIS Framework

  • Andy Leonard
  • Tim Mitchell
  • Matt Masson
  • Jessica Moss
  • Michelle Ufford
Chapter

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

Keywords

Precedence Constraint Event Handler Application Instance Variable Window Connection Manager 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Andy Leonard 2014

Authors and Affiliations

  • Andy Leonard
    • 1
  • Tim Mitchell
    • 1
  • Matt Masson
    • 1
  • Jessica Moss
    • 1
  • Michelle Ufford
    • 1
  1. 1.VAUnites States

Personalised recommendations