Advertisement

Scripting Patterns

  • Andy Leonard
  • Matt Masson
  • Tim Mitchell
  • Jessica M. Moss
  • Michelle Ufford

Abstract

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.

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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Andy Leonard, Matt Masson, Tim Mitchell, Jessica M. Moss, and Michelle Ufford 2012

Authors and Affiliations

  • Andy Leonard
  • Matt Masson
  • Tim Mitchell
  • Jessica M. Moss
  • Michelle Ufford

There are no affiliations available

Personalised recommendations