Get started with BimlExpress

BimlExpressSay welcome to BimlExpress – the newest, shiniest and completely free Biml toy! :) I first mentioned BimlExpress at SQLSaturday Vienna and have been waiting for the official release since then. I’m very happy that I can now send you all over to Varigence’s website to download the Visual Studio Add-in!

What is BimlExpress?

BimlExpress is a free Visual Studio add-in for working with Biml in your SSIS projects. It allows you to add and edit Biml files, generate SSIS packages from Biml, and the code editor is fully featured with syntax coloring, error highlighting and intellisense.

If you are already using BIDS Helper, you will see that BimlExpress works the same way and includes all the same Biml features as in BIDS Helper – just with a new and improved code editor. No more squiggly red lines, yay!

Should I use BimlExpress or BIDS Helper?

Both! :) BIDS Helper is a fantastic, free add-in with a ton of useful features for your Business Intelligence projects. The release of BimlExpress simply means that Varigence can update the add-in and the Biml engine with new features more frequently and separately from BIDS Helper. When BIDS Helper is updated it will include the latest Biml engine. Keep using BIDS Helper, and install BimlExpress as well for the latest Biml features.

And all of you Biml fans agree with me that the new code editor is worth it, right? Right!? :)

How do I get started with BimlExpress?

Installing

Download and start the installation. Select which versions of Visual Studio you want to install (or update) the add-in for, wait a couple of seconds, and you can start writing Biml!

Install BimlExpress 1/4 Install BimlExpress 2/4 Install BimlExpress 3/4 Install BimlExpress 4/4

Menus

After installing, you will see a new toolbar menu:
BimlExpress Toolbar Menu

If you click on Learn Biml you will be taken to BimlScript.com, and About BimlExpress will show you things like the Build version and product key information:
About BimlExpress

In the solution explorer, you can right-click on a Biml file to see a similar menu:
BimlExpress Right-Click Menu

Help! I see double!
Do you see both the BimlExpress and the BIDS Helper menu items?
BimlExpress and BIDS Helper
Just go to the toolbar menu and click Toggle BIDS Helper Menus :)

Code Editor

If you have been working with Biml and BimlScript using BIDS Helper, you know how painful it is when the syntax coloring stops working, the intellisense stops working, and you get a ton of squiggly red error lines that aren’t really errors when mixing Biml and BimlScript. Not anymore! Look at the pretty BimlScript code nuggets highlighting and functional intellisense :)
BimlExpress Code Editor

Uninstalling

If you need to uninstall or disable BimlExpress, you can do so by going to ToolsExtensions and Updates:
Uninstall BimlExpress 1/2

Then choose to Disable or Uninstall BimlExpress:
Uninstall BimlExpress 2/2

(You can also uninstall from the Control Panel.)

Happy Bimling! :)

Biml Express All The Things
Biml All The Things – Express Version!

(Thank you so much for this release and the great support, Varigence :D)

Who is Cathrine Wilhelmsen?

Cathrine is a SQL Server Data Warehouse architect and Business Intelligence developer. She organizes, volunteers and speaks at SQLSaturdays, and is a proud Microsoft Data Platform MVP and BimlHero Certified Expert. She loves sci-fi, fantasy, coffee, chocolate and smilies :)

11 thoughts on “Get started with BimlExpress”

Pingback: BimlExpress – Curated SQL

Hi Cathrine, I have just installed BimlExpress for Visual Studio 2012 successfully but it is not working. When I click on Check Biml For Errors after adding one BIML script which works in BidsHelper. I got following error “Could not load file or assembly ‘Microsoft.DataWarehouse.Interfaces, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.”
I have Office 2013 and SQL 2012 installed on my machine. It looks like BimlExpress somehow looking into Excel 2016 assembly but I am not sure. Do you have any comments on the same?

Hi Manish, I have not encountered this error. I’d recommend posting your question and code to the official Varigence Biml support forum :)

Thanks Cathrine :-) I will do that right away.

Hi Manish, I getthe same error, were you able to resolve it?

I received the same error. I resolved it by doing the following:

1) Install VS 2013 Isolated: https://www.microsoft.com/en-us/download/details.aspx?id=40764
2) Install VS 2013 Integrated: https://www.microsoft.com/en-us/download/details.aspx?id=40777
3) Install SSDT for VS 2013: https://www.microsoft.com/en-us/download/details.aspx?id=42313

Afterwards, I was able to compile Biml in VS2012

Hi. Since Varigence won’t reply to my mails I’ll try here as well.
Trend micro (my company’s anti virus solution) blocks BimlExpress because of malicious behavior and virus/Malware which makes it impossible for me to install it on my work laptop. I did download it directly from Varigence.

I’ve also seen a post on the Varigence forum stating that Symantec Enpoint protection also blocks it.
This is, as you can understand a show stopper for me, and the fact that Varigence isn’t responding is not a good sign. Have you encountered this problem or heard anything about it?

Hi again.
I just received an answer from Varigence. They have been in contact with Trend Micro so hopefully the problem will be resolved shortly

Hi,
Since last week i have googled about BIML & BIML script and try to implement with BIDS helper ,as a beginner it was difficult to code with BIML SSIS syntax bcoz till now have built ssis using GUI shape provided by Microsoft and it’s easy.

All the articles i have read till now in my opinion are little bit messy if a user implement demo by them.
If there is any e-book or any other stuff to learn basic of BIML for SSIS please share.
I also tried MIST it also too complex to understand .

I have installed BIML express as per the screenshots and I dont get the options from the Drop down menu in VS 2015. It only offers 3 options: Learn, About and Toggle, am I doing something wrong??

Hi Nathan, have you created or opened an SSIS project? If you don’t have an SSIS project open (or have a different kind of project open), you will only see the Learn, About and Toggle options.

Share Your Thoughts?