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 14. Programming SSIS

by Reza Rad

In this chapter, we will cover the following topics:

  • Creating and configuring Control Flow Tasks programmatically
  • Working with Data Flow components programmatically
  • Executing and managing packages programmatically
  • Creating and using Custom Tasks

Introduction

SSIS is a Rapid Application Development tool. This means that SSIS developers won't need to write any code to do operations. On the other hand, we saw in Chapter 8, Scripting, that there are two script components that help developers to write their own customized .NET code to do any specific operation which is not listed in SSIS built-in components. All of these features are not enough for calling an ETL tool as an enterprise, because enterprise environment ...

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