Advertisement

Scripting Patterns

  • Andy Leonard
  • Tim Mitchell
  • Matt Masson
  • Jessica Moss
  • Michelle Ufford
Chapter

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.

Keywords

Naming Convention Visual Studio Code Reuse Connection Manager Script Editor 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Andy Leonard 2014

Authors and Affiliations

  • Andy Leonard
    • 1
  • Tim Mitchell
    • 1
  • Matt Masson
    • 1
  • Jessica Moss
    • 1
  • Michelle Ufford
    • 1
  1. 1.VAUnites States

Personalised recommendations