Building Blocks of Biml

This course teaches SQL Server Integration Services (SSIS) developers how to develop packages to perform extract-transform-load (ETL) operations for a data warehouse by using Business Intelligence Markup Language (Biml) as an alternative development approach.

It’s generally accepted that creating and maintaining ETL packages with SQL Server Integration Services (SSIS) is one of the more time-consuming steps in the data warehouse development process, but what if there was a way to save time that can be used to solve bigger problems or expand the data warehouse scope? Rather than spend seemingly endless hours working through repetitive SSIS package development tasks and more hours tweaking those packages as schemas evolve, you can use Biml to create a framework that gracefully adapts to changes and updates package designs in minutes. This course introduces you to the Biml language by progressively building out files to support a data warehouse environment until you have a complete solution for staging data and loading the staged data into target dimension and fact tables.

• Introducing Biml 34mins
• Creating Your First Biml Files 29mins
• Exploring Basic Biml Syntax in the Control Flow 27mins
• Exploring Basic Biml Syntax in the Data Flow 29mins
• Introducing Biml Automation 20mins
• Automating Biml with Multiple Files 39mins
• Building Biml for Data Warehousing - Part 1 23mins
• Building Biml for Data Warehousing - Part 2 45mins