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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
