O'Reilly logo

Microsoft® SQL Server® 2012 Integration Services by Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required