Introduction

When developing an integration SSIS project the most common concern is to guarantee that the data extracted from the source will be available to the end users as fast as possible. But if the scenario that lies ahead has huge data volumes moving from one source to some destination, performance concerns arise. What worked in a small data set will not work on big data sets.

If you keep in mind from an initial stage which tasks and which components should be used or avoided, and have a clear idea about when you should or shouldn't use the SSIS, it will help you to be more prepared for these scenarios. For this you need to understand the SSIS tool and the techniques that enable you to optimize the tool's utilization of system resources such as memory and CPU.