Summary

During this project, you gained some experience with most of the transforms and more than a few of the common tasks in the Toolbox. You learned firsthand that the new Data Flow is powerful, because you worked through typical staging logic in memory without having to commit the data and witnessed the results of the new Fuzzy Lookup transformations. You saw how visual the environment is and how easy it is to understand what is going on with the stream as it is being transformed. Transforming is what you do in the Data Flow, not in the Control Flow — even though it looks like a Control Flow page.

This case study provided an in-depth look at the new capabilities of the SSIS development environment. It is a real development environment now. That is why you first started with some business requirements and worked through the exercise like a development project. You focused on the nuts and bolts of error handling, naming conventions, and some practical tips for testing. Hopefully you saw a few things that you can use to solve that problem on your desk with SSIS 2005.