O'Reilly logo

SQL Server 2012 Integration Services Design Patterns by Michelle Ufford, Matt Masson, Jessica M. Moss, Andy Leonard, Tim Mitchell

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 10

image

Expression Language Patterns

Expression language in SSIS might appropriately be referred to as the “glue” that holds the product together. Expressions in SSIS provide a relatively simple and easy-to-use interface to allow data developers to introduce dynamic logic into the ETL infrastructure. Thinking through the various moving parts within Integration Services, it’s safe to say that they can all be manipulated in one way or another through the use of expressions.

Expressions provide a fast, effective, and—dare I say—fun way to solve specific ETL challenges. In this chapter, we’ll look into some of the basics of the expression language, ...

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