CHAPTER 3

image

Scripting Patterns

As I have shown throughout this book, SQL Server Integration Services is a multifaceted product, with many native capabilities that can handle even the most difficult of data challenges. With highly flexible transformations, such as the Lookup, Conditional Split, Derived Column, and Merge Join, the data flow is well-equipped to perform a limitless number of transformations to in-flight data. On the control flow side, tools including the File System Task, For Each Loop (and its cousin, the For Loop), File System Task, and Data Profiling Task provide critical services to support fundamental ETL operations. Right out ...

Get SQL Server 2012 Integration Services Design Patterns now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.