This chapter explains techniques to create complex processes, for example, iterating over jobs or manipulating lists of files. You will learn about the following topics:
- Enhancing your processes with the use of variables
- Accessing copied rows for different purposes
- Working with file lists
- Executing jobs in an iterative way
This chapter is closely related to Chapter 12, Creating Portable and Reusable Transformations. Many concepts that apply to transformations are revised but this time applied to jobs. So if you skipped that chapter, it's a good idea to read it before reading this one.