Hands-On Microsoft SQL Server 2008 Integration Services part 14. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 108 Hands-On Microsoft SQL Server 2008 Integration Services constraints are also enhanced beyond DTS 2000 as they can include expressions to consider along with execution results of the precedence executable. Finally the most powerful feature of Integration Services is its ability to evaluate the properties dynamically at run time. This is achieved with Property Expressions. Integration Services Expression language is rich in syntax and can be used to create complex expressions using variables columns functions and operators. After having learned about connection managers system- and user-defined variables precedence constraints and the Expressions language it s time for you to start building packages using these components. Chapter 4 Integration Services Control Flow Containers In This Chapter c Integration Services Package c Foreach Loop Container c For Loop Container c Sequence Container c Task Host Container c Summary 110 Hands-On Microsoft SQL Server 2008 Integration Services Integration Services SSIS uses containers to host functional objects that build packages. An SSIS container is an object that represents a unit of work and contains the tasks and precedence constraints. A container can contain other containers and tasks. So while you are creating an SSIS package you will be adding and configuring tasks inside a container that will provide necessary services to your tasks to accomplish the work that needs to be done. Functionally SSIS containers provide repeating logic the ability to enumerate over a set of items and the ability to group tasks and child-containers to create an independent unit of work that can communicate with a parent container. In this chapter you will study the following five Integration Services containers Integration Services package Foreach Loop Container For Loop Container Sequence Container Task Host Container You will study another container available in SSIS the Event Handler in Chapter 8. Its primary function is to support a .
