Introduction to Biml An overview of Business Intelligence Markup Language (Biml). Includes demonstrations of: Building an empty SSIS package in Biml Using BimlScript to create one empty package per table Using a simple metadata-driven framework built in BimlExpress to build a simple staging SSIS application. Obtain and Install BimlExpress A short course that describes acquiring […]
The SSIS courses are designed “spiral-out” and “hands-on.” Spiral-out means start in the center, at the heart of the platform, and then build learning and experience around that center. Hands-on reflects the fact that we learn best by doing. Combined, spiral-out and hands-on are the best way to learn technology (or anything).
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.”
SSIS Scripting demonstrates the SSIS Script Task and the SSIS Data Flow Task’s Script Component, and includes .Net scripting basics in C# and Visual Basic. Andy shares templates for raising Information and Error events.
Because Andy Leonard believes you learn best by doing, the first SSIS Data Flows course lecture demonstrates how to create an SSIS project and build your very first data flow task that includes a Flat File Source Adapter and Flat File Connection Manager to read data from a real-world source file (for http://andyweather.com) and write.