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

Sequence Container: putting all tasks in an executable object

Sequence Container is the first container which will be covered in this chapter. SSIS Control Flow Tasks play an executable role and each task is an executable. Every executable can have one or more precedence constraints, and one or more outputs.

The Sequence Container will group one or more executable together and create an executable object. Transactions and some settings can be applied on a Sequence Container. We will discuss this in the later recipes.

In this recipe, we will reveal a sample of the Sequence Container and we will demonstrate when and how a Sequence Container will be helpful.

How to do it...

  1. Create a SSIS project and name it as R01_Sequence Container.
  2. Add a Sequence Container ...

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