Summary

The flexibility of Integration Services brings more design options and in turn requires you to give more attention to establishing the architecture. As you've seen in this chapter, bringing over a DTS-based architecture to Integration Services also brings over the design and processing flaws with no real advantage gained from the new Integration Services features. Leveraging the Data Flow in Integration Services reduces processing time, eases management, and opens the door to scalability. Therefore, choose the right architecture up front and it will ease the design burden and give overall gains to your solution.

Once you have established a model for scalability, the reduced development time of Integration Services will allow attention to be given to optimization, where fine-tuning the pipeline and process will make every second count.