O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8. Scripting

by Reza Rad

In this chapter, we will cover the following topics:

  • The Script Task: Scripting through Control Flow
  • The Script Component as a Transformation
  • The Script Component as a Source
  • The Script Component as a Destination
  • The Asynchronous Script Component

Introduction

In previous chapters, many aspects of SSIS Development Components were revealed. SSIS has a bunch of Tasks and Transformations that help ETL or Data Integration developers to create their package faster, more easily, and with greater reliability. However, there are times when a requirement cannot be met with built-in tasks and transformations. Every ETL Tool should have a way to overcome this common problem.

SSIS provides a way to write your own custom code in a .NET ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required