September 2012
Beginner to intermediate
672 pages
21h 25m
English
book
Microsoft® SQL Server® 2012 Integration Services
by Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam
Content preview from Microsoft® SQL Server® 2012 Integration ServicesBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...