Explore SQL Server 2016 Integration Services (SSIS 2016) package tuning techniques in this informative conference talk. Join SSIS author Andy Leonard as he demonstrates test loads using sample and real-world data, showcasing methods to optimize performance. Learn about removing blobs, handling mapping errors, executing calculators, and managing blob loads. Discover strategies for incremental loading, implementing lookups, and detecting changes in your data. Gain insights through live demonstrations and practical examples of data flow operations. Enhance your SSIS skills and improve the efficiency of your data integration processes with expert guidance and real-world scenarios.
Overview
Syllabus
Introduction
Presentation Overview
Demo
Remove Blobs
Mapping Errors
Running Calculator
Blob Load
Blob Temp
Live Demo
Incremental Load
Lookups
Change Detection
Change Detection Demo
Data Flow Example
Questions
Conclusion
Taught by
PASS Data Community Summit
