Abstract
As shown throughout this book, SQL Server Integration Services (SSIS) 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, the For Each Loop (and its cousin, the For Loop), the File System task, and the 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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Andy Leonard
About this chapter
Cite this chapter
Leonard, A., Mitchell, T., Masson, M., Moss, J., Ufford, M. (2014). Scripting Patterns. In: SQL Server Integration Services Design Patterns. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0082-7_3
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0082-7_3
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0083-4
Online ISBN: 978-1-4842-0082-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books