SSIS: The Data Flows Part 2
SSIS (SQL Server Integration Services) is a tool for data transformation. SSIS Data Flows Part 2 builds on SSIS Data Flows Part 1 by adding a correlating Lookup and subsequent Conditional Split transformations to prevent data re-loading or loading duplicates. This addition introduces the first order of an Incremental Load SSIS design pattern that Andy calls “Forward-Only Incremental Load.”
Link to the agenda and sample videos from the course
Length: 25 Minutes
Andy Leonard is founder and Chief Data Engineer at Enterprise Data & Analytics, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS Trainer, Consultant, and developer, a Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of The Biml Book and SQL Server Integration Services Design Patterns and author of Managing Geeks – A Journey of Leading by Doing, Data Integration Lifecycle Management with SSIS, Building Custom Tasks for SSIS, and the Stairway to Integration Services. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.
There are no reviews yet.