Hands-On Microsoft SQL Server™ 2005 Integration Services

Chapter 4. Integration Services Control Flow Containers

In This Chapter

Integration Services Package Foreach Loop Container For Loop Container Sequence Container Task Host Container Summary

If you have worked with Data Transformation Services (DTS 2000), you know that the DTS packages are configured using tasks connected by precedence constraints. Integration Services (SSIS) uses a slightly different concept of building packages inside a container—that is, the container actually contains the tasks and precedence constraints. SSIS containers are the objects that represent a unit of work. 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 ...