This chapter focused on driving home the basic SSIS transforms, tasks, and containers. You performed a basic ETL procedure and then expanded the ETL to self-heal when bad data arrived from your data supplier. You then set the package to loop through a directory, find each .DAT file, and load it into the database. The finale was archiving the file automatically after it was loaded. With this type of package now complete, you could throw any .DAT file that matched the format you configured and it will load with reasonable certainty. In the upcoming chapter, you'll dive into some more advanced tasks and transforms that use the Advanced Editor.