O'Reilly logo

SQL Server MVP Deep Dives by Greg Low, Paul Randal, Kimberly Tripp, Adam Machanic, Kalen Delaney, Paul Nielsen

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 57. Expressions in SQL Server Integration Services

Matthew Roche

SQL Server Integration Services (SSIS) is Microsoft’s enterprise extract, transform, and load (ETL) platform, and is used in large-scale business intelligence projects and small-scale import/export jobs around the world. Although SSIS contains an impressive set of features for solving a range of data-centric problems, one feature—expressions—stands out as the most important for SSIS developers to master.

Expressions in SSIS are a mechanism to add dynamic functionality to SSIS packages; they are the primary tool that SSIS developers can use to build packages to solve complex real-world problems. This chapter examines SSIS expressions from the perspective of providing elegant ...

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