O'Reilly logo

SQL Server Integration Services Design Patterns, Second Edition by Michelle Ufford, Jessica Moss, Matt Masson, Tim Mitchell, Andy Leonard

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 2

image

Execution Patterns

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.

You can build awesome SQL Server Integration Services (SSIS) packages, but they do you no ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required