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

Please note that BimlExpress 2017 does not yet work with Visual Studio 2017 due to breaking changes in how Visual Studio 2017 manages extensions.

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!

OH YEAH! :)

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

IS THIS COOL OR WHAT? :D

.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.

Summary

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!

Please note that BimlExpress 2017 does not yet work with Visual Studio 2017 due to breaking changes in how Visual Studio 2017 manages extensions.

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

Who is Cathrine Wilhelmsen?

Cathrine is a Microsoft Data Platform MVP, BimlHero, author, 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, craft beers, ciders, cat gifs and smilies :)

21 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 support@varigence.com, and I’m sure they can help you out :)

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

Have you had any issues with script components not referencing the same dll versions as the SSIS target version? Currently when I export from VS 2015 targeting 2012, my script component tries to reference version 14.100 DTS assemblies.

Hi again cathrine, could you give an example of the devart mysql connector being used? I can’t bring it up in intellisense and the varigence website haven’t yet updated their snippets page so I can’t find the correct syntax for the tag!

Thanks!

Hi Cathrine, is this compatible with Visual Studio 2017 Community version?

I am getting below error in the log:-

– Found installed product – Visual Studio Community 2017
– VSIXInstaller.NoApplicableSKUsException: This extension is not installable on any currently installed products.

BimlExpress 2017 does not yet work with Visual Studio 2017 due to breaking changes in how Visual Studio 2017 manages extensions.

Hi guys, just a heads-up warning,
Script tasks stopped working with Biml Express 2017.
See this thread for updates or Varigence feedback https://www.varigence.com/Forums?threadID=9832
Joel

Hi, we upgraded to the new BIMLExpress and some of our BIML scripts don’t work anymore. In the 2016 version we got warnings like “Input contains multiple columns named,…”. In the 2017 version it fails over this with error “EmitSsis contains fatal errors ….. NullReferenceException”. How can we avoid this error ? e.g. column SECTORNAME it’s datatype has changed and it is renamed to SectorName.

Hi, I’m getting the following error in the log when opening the installer, together with some warnings about data collision in the registry:
PKGDEF Error: Nothing to unlock for PkgDef mutex, PKGDEF: 8000FFFF

Installer stops then.
I’m using Visual Studio Pro 2017. Any thoughts?

Hi Niek, when I tried to install it, I was not able to install it for Visual Studio 2017, I could only install it for VS2015 (I have both VS’s installed). are you using the latest VSIX installer ?

Hi, I’m having the same problem with Visual Studio 2017. Is this version not suitable to visual studio 2017 professional?

BimlExpress 2017 does not yet work with Visual Studio 2017 due to breaking changes in how Visual Studio 2017 manages extensions.

BimlExpress 2017 does not yet work with Visual Studio 2017 due to breaking changes in how Visual Studio 2017 manages extensions.

BimlExpress 2017 does not yet work with Visual Studio 2017 due to breaking changes in how Visual Studio 2017 manages extensions.

I also am unable to get a successful install on VS 2017 professional as well. is this isolated to unique cases, or are other people experiencing similar results?

BimlExpress 2017 does not yet work with Visual Studio 2017 due to breaking changes in how Visual Studio 2017 manages extensions.

Share Your Thoughts?