Faster SSIS
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
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.
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
Related Courses
Web sémantique et Web de donnéesInria (French Institute for Research in Computer Science and Automation) via France Université Numerique Linked Data Engineering
openHPI Implementing ETL with SQL Server Integration Services
Microsoft via edX Advanced Manufacturing Enterprise
University at Buffalo via Coursera Big Data Services: Capstone Project
Yandex via Coursera