Short Cuts to Biml Mastery

I’ve been giving Biml related presentations for many years, and shared what I believe are the most efficient ways to learn it. It’s possible to get enough Biml knowledge...

Introduction to the Biml Language

Biml or Business Intelligence Markup Language is an open-source XML dialect to generate Integration Services (SSIS) packages. Take a look at this Biml tutorial to learn how you can use Biml to generate SSIS packages.

Developing Metadata Design Patterns in BIML

You may have already experienced ETL Hell, where you have a large number of similar of SSIS tasks, and a small change, such as an alteration to the network topology, means that they all need to be altered with the correct connection details. Perhaps you should consider creating design patterns for all the standard components of integration tasks in BIML, and generating the SSIS packages from these? Amarendra walks you through the process.

Biml Academy 2 - Importing, Staging, and Loading Data

Next week are 5 more lessons on working iwth Bilm. Each day, Aug 15-19, at 1:00pm EDT.

Announcing BIML Academy

Join Andy Leonard the week of May 9-13 for 5 free days of BIML training.

BimlScript Indicators

Biml

Generate multiple SSIS packages using BIML and metadata

Although BIML is very powerful, you wouldn’t use it to generate one package at a time. Using metadata, we can generate multiple packages on the fly. Koen Verbeeck illustrates how to convert the BIML script for generating the import package to a dynamic package generating machine.