Performance Tuning SSIS. Brian Knight, CEO Pragmatic Works firstname.lastname@example.org. About the Ugly Guy Speaking. SQL Server MVP Founder of Pragmatic Works Co-Founder of BIDN.com, SQLServerCentral.com and SQLShare.com Written more than a dozen books on SQL Server. Mobile data.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Brian Knight, CEO Pragmatic Works
Legacy data: binary files
SQL Server Integration Services
Application databaseIntegration Services in Action
Integration is a seamless, manageable operation
Source, prepare, & load data in single, auditable process
Scale to handle heavy and complex data requirements
* Not official Microsoft results.
Connection manager tuning
Flat file tuning
OLE DB Source tuning
Synchronous vs. Non Synchronous
Traditional CDC with SSIS
Integrating CDC in 2008
Cascading lookup optimizations
Cache file lookup
Create a work queue table.
Create a loop to shift over the work queue constantly checking out work
Spawn x times with a batch file
Creating a soft schedule cap