Chapter 21. SSIS Performance Best Practices

As you have seen in earlier chapters, SSIS has become the de facto platform for performing extract–transform–load (ETL), data warehousing, and other data movement-related activities. It is capable of scaling to handle data loads ranging from small departmental databases sized in gigabytes to massive multiterabyte data warehousing systems. To optimize performance of SSIS while handling larger data loads might require some tuning. One of the primary advantages of SSIS is its simplicity, so a new developer can quickly start creating and executing packages to handle small data loads. However, it also supports ...

Get Microsoft® SQL Server® 2012 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.