Skip to content

Biml updates in BIDS Helper 1.7.0 and Mist 4.0

↓ Click to read full article

Biml (Business Intelligence Markup Language)

2015 is such an exciting year for everyone using Biml! Varigence recently released version 4.0 of Mist, and now version 1.7.0 of BIDS Helper is released. Both products have implemented the changes to the Biml language, and they have both been upgraded with new features and improvements. Only some of the changes are mentioned in this post, but you can find the full release notes here:

Bids Helper 1.7.0 Downloads and Release Notes
Mist 4.0 Release Notes
Mist 4.0 Update 1 Release Notes
Mist 4.0 Webinar Recording on YouTube

Biml language highlights

Nested included files now work.

ConstraintMode is no longer a required attribute on SSIS packages, but the default has been set to Parallel so you will still need to specify the ConstraintMode if you want to create a Linear package:

<!-- Now valid: -->
<Package Name="EmptyPackage" />

Hadron is no longer used, and all namespaces that included “Hadron” have 1:1 replacements with “Biml”:

<!-- No longer valid: -->
<#@ import namespace="Varigence.Hadron.CoreLowerer.SchemaManagement" #>
 
<!-- Now valid: -->
<#@ import namespace="Varigence.Biml.CoreLowerer.SchemaManagement" #>

New code directive to reference C# or VB files directly from BimlScript:

<#@ code file="C:/Common/SharedScript.cs" #>

New Change Data Capture tasks and components: CDC Control Task, CDC Source and CDC Splitter:

CdcControl
CdcSource and CdcSplitter

BIDS Helper 1.7.0 highlights

Properly supports emitting SSIS 2014 packages in SSDTBI for Visual Studio 2013!

Shows a progress bar when Checking Biml For Errors or Generating SSIS Packages:

Checking Biml For Errors

More useful errors dialog and brings the Output window to the front:

Changed Hadron to Biml

Mist 4.0 highlights

New Metadata Modeling! (Mist 4.0 Metadata Preview on YouTube)

True Multiple Document Interface (MDI), multiple editor windows can be open at the same time (yay tab groups!):

Multiple Document Interface (MDI)

Logical View and Ribbon revamp for more intuitive grouping:

Mist 4.0 Logical View
Ribbon

New designerbimlpath attribute in the template directive so intelliprompt works correctly on code fragments like callable BimlScripts or include files:

designerbimlpath

Improved intelliprompt completion lists and option to toggle content:

Intelliprompt Toggle Extension Methods

…and much, much, much more, YAY! :) Read and/or see all the changes here:

Bids Helper 1.7.0 Downloads and Release Notes
Mist 4.0 Release Notes
Mist 4.0 Update 1 Release Notes
Mist 4.0 Webinar Recording on YouTube

Who is Cathrine Wilhelmsen?

Cathrine is a Microsoft Data Platform MVP, BimlHero, Microsoft Certified Solutions Expert, author, speaker, blogger and chronic volunteer who loves teaching and sharing knowledge. She works as a Senior Business Intelligence Consultant in Inmeta, focusing on Azure and the Microsoft Data Platform. She loves sci-fi, chocolate, coffee, craft beers, ciders, cat gifs and smilies :)

Comments

Hi! This is Cathrine. Thank you so much for visiting my blog. I'd love to hear your thoughts, but please keep in mind that I'm not technical support for any products mentioned in this post :) Off-topic questions, comments and discussions may be moderated. Thanks!

Click to Show / Hide Comments