It’s generally accepted that creating and maintaining ETL packages is one of the more time-consuming steps in the data warehouse development process. Which would you rather do with your time? Spend seemingly endless hours working through repetitive SSIS package development tasks and more hours tweaking those packages as schemas evolve? Or invest in a framework that gracefully adapts to changes and updates your package designs in minutes so you can spend your time solving bigger problems or expanding the scope of your data warehouse?
In this full-day workshop, you’ll learn about Business Intelligence Markup Language (Biml), your secret weapon for saving time on SSIS package development. We’ll start by learning about the history of Biml, the tools you can use to work with Biml, what it looks like, and the problems it’s designed to solve.
Then we’ll dive into the syntax of Biml by building out a simple SSIS package step by step. You’ll learn the structure of a Biml file and how to generate a package that you can view in Business Intelligence Development Studio (BIDS) or SQL Server Data Tools for BI (SSDT-BI).
Next, we’ll explore how to use BimlScript to automate package development. You’ll learn how to use control blocks to conditionally generate sections of Biml or even complete Biml files. For example, you can programmatically read a collection of tables from your source and generate a set of extraction packages to extract data from those tables into a corresponding staging table, among other capabilities that you’ll learn about in this portion of the workshop. You’ll also learn how to break up Biml instructions into multiple files and how to use directives to manage the way in which Biml is interpreted across multiple files.
With these building blocks in place, we’ll examine a simple framework for using Biml to create a package to support the full ETL process from metadata. You’ll learn how easily Biml can update packages to reflect changes in your source or target schemas. In addition, you’ll have a set of example Biml files that you can adapt to fit your environment and start saving time on your package development efforts!
Stacia Varga is a SQL Server MVP and SSAS Maestro with a Bachelor’s degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 25 years, with a focus on improving business practices through technology.
Since 2000, Stacia has been providing consulting and education services for Microsoft's Business Intelligence technologies. During that time, she has also authored several books covering the Microsoft BI stack as Stacia Misner.
Do you have questions about Stacia Varga - Building Blocks of BIML?
Contact Southampton Data Platform User Group