Chapter 8

Creating an End-to-End Package

WHAT’S IN THIS CHAPTER?

• Walking through a basic transformation
• Performing mainframe ETL with data scrubbing
• Making packages dynamic

Now that you’ve learned about all the basic tasks and transformations in SSIS, you can jump into some practical applications for SSIS. You’ll first start with a normal transformation of data from a series of flat files into SQL Server. Next you’ll add some complexity to a process by archiving the files automatically. The last example demonstrates how to make a package that handles basic errors and makes the package more dynamic. As you run through the tutorials, remember to save your package and your project on a regular basis to avoid any loss of work.