Execution Patterns

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

Abstract

To fully understand SQL Server 2014 Integration Services execution, you must first understand the different deployment models. There are two: the package deployment model and the project deployment model. Each exposes and supports a different functionality. The package deployment model primarily supports legacy functionality. It is the model used in SSIS 2005 through SSIS 2008 R2. The new way of doing things involves the project deployment model. Certain execution methods, but not all, are available to both deployment models.

Keywords

File System Integration Service Custom Schema Deployment Model 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