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 of the box, you get a toolbox that’s full of flexible and powerful objects.
KeywordsNaming Convention Visual Studio Code Reuse Connection Manager Script Editor
Unable to display preview. Download preview PDF.