Summary

In this chapter, you learned about containers and transformations. Containers allow you as an SSIS developer to group tasks or loop through a series of tasks. Transformations allow you to change the data from a source or another transform and pass the results as output to a destination or another transformation in the path. In the next chapter, you will use what you have learned over the past two chapters to create a few packages that will perform typical ETL tasks for you.