New Release: BimlExpress 2017!

BimlExpress 2017What day is it today? It’s the BimlExpress 2017 release day! Yay! :) I’ve waited for this release for a long time, and I know I’m not the only one. People have asked me many times if Varigence is still around. The answer is most definitely yes! It has been rather quiet from Varigence this past year, and I know we’ve all been waiting for news and updates. But don’t forget that they’re a small company, and that they’re actually giving us BimlExpress for free. They’ve focused on development this past year, and have been working like crazy to rewrite the Biml engine, add new features to BimlExpress, rebrand Mist to BimlStudio and make it even more powerful, and finish their BimlFlex framework. And today? Today we all get to enjoy the new releases! More yay! :)

Download and install BimlExpress 2017

You can download BimlExpress 2017 from the Varigence BimlExpress page:
BimlExpress Download VSIX

The new installer is a lightweight VSIX (Visual Studio Extension) Installer:
Install BimlExpress 2017 - License Agreement Install BimlExpress 2017 - In Progress Install BimlExpress 2017 - Finished

After installing, you will find BimlExpress in the list of Visual Studio Tools and Extensions:
BimlExpress 2017 Visual Studio Extension

What’s New in BimlExpress 2017?

I will show you some of the exciting new features below. Spoiler alert: there are some gamechangers in this release! Let’s take a look at some of the exciting new features in BimlExpress 2017 :)

Webinar recording

If you prefer to see demos of the new features, take a look at the webinar I did with Varigence:


Preview Expanded Biml

Ok, I know the rest of the post won’t be as exciting when I start with the coolest feature, but this is such a big gamechanger that I want to show it off before you close this tab and move on to the next blog post ;)

Remember all those tips about how you can use RootNode.GetBiml() in a high-tier helper file to save your expanded Biml to a file for debugging?

Yeah. Forget that. You can now preview your expanded Biml directly in BimlExpress, just like you can in BimlStudio!


This is going to make it so much easier to teach, learn and write Biml.

All you have to do is write some code and watch the Biml compile. Depending on your BimlExpress settings, you may have to click on the Show Preview button to open the preview pane, or click on Update to start compiling:

BimlExpress 2017 Preview Expanded Biml


.NET intellisense

Wait, what? .NET intellisense? Does that mean C# and VB intellisense? You bet it does!

Now, let’s start with a small disclaimer. The release notes say: “Added preview mode of .NET intellisense for early adopters”. That means that this feature is not available out of the box for everyone, it has to be enabled per product key by Varigence. So how do you get it? It’s very simple: E-mail Varigence. Help them out by providing feedback and suggestions for improvements. If you want to go crazy, you may even mention BimlExpress in social media, blog posts or if you’re presenting somewhere. But that’s not a requirement. Just e-mail Varigence and ask. They’re nice guys :)

So how does .NET intellisense work? Create a BimlScript code nugget and start typing. Just like regular Biml intellisense, the list will be filtered based on what you type, and you can filter further by using the buttons at the bottom:

BimlExpress 2017 .NET (C# / VB) Intellisense

Woop woop!

Global Include Files

Using include files is a great way to separate code so you can maintain it in just one file, and it just got better! With the new global directive, you can create files that will automatically be included in your entire project – without having to insert the include directive in every single Biml file. This is great for creating global variables, including code files, or to make VB default for your entire solution :)

The only thing you need to do is to add the new global directive to your include file:

You can control the global include files by using directive attributes:

Order: Specifies the order in which to include the files, starting with the lowest number.
Location: Can be top or bottom. Specifies where the content of the global include file will be added.
Active: Can be True or False. Provides a way to quickly turn on and off global include files, for example for testing vs. generating for production.
ApplyToCallBimlScript: Can be True or False. Specifies if the global include file should be included in CallBimlScript callee files.

Pretty handy, huh? :D

SSIS Annotations

You can now add SSIS Annotations to packages, containers, event handlers, and data flows! This only works for SSIS 2012 and higher. The syntax is very simple:

The generated package will include the annotations:
BimlExpress 2017 SSIS Annotations

This is a great new feature, especially if you have mixed projects where only some packages are generated from Biml, or mixed development teams where only some developers use Biml.


BimlExpress 2017 has finally been released, and you can download it from the Varigence BimlExpress page. Some of the gamechanging features are Preview Expanded Biml, .NET intellisense, Global Include Files and SSIS Annotations. But wait! There’s more! I haven’t covered all features in this blog post. You can find all the changes in the full release notes.

Download it today and try it out yourself!

Thank you for making my life so much easier, Varigence :)

Who is Cathrine Wilhelmsen?

Cathrine is a Microsoft Data Platform MVP, BimlHero, speaker, blogger and chronic volunteer who loves teaching and sharing knowledge. She works as a consultant, technical architect and developer, focusing on Data Warehouse and Business Intelligence projects. She loves sci-fi, chocolate, cat gifs and smilies :)

7 thoughts on “New Release: BimlExpress 2017!”

Does the previous version of BIML Express has to be manually uninstalled from Visual Studio before installing BIML Express 2017?

I recommend uninstalling the old BimlExpress before installing the new one :)

Pingback: BimlExpress 2017 – Curated SQL

Catherine, I can’t download from the Varigence website… my firewall is picking it up as malware… any help?

*Cathrine …my apologies for spelling your name wrong!

Hi Adam, no worries! You can e-mail Varigence at, and I’m sure they can help you out :)

Pingback: The Basics – BIML : Preview Pain & Multiple File Dependencies | SI Bytes

Share Your Thoughts?