SQL Server MVP Deep Dives
by Adam Machanic, Greg Low, Kimberly Tripp, Paul S. Randal, Kalen Delaney, Paul Nielsen
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access