Skip to content

Category: Biml

These posts are about Biml (Business Intelligence Markup Language), BimlScript, BimlExpress, BimlStudio, BimlOnline, the BimlHero Certified Expert Program and events by the Biml community or Varigence. Older posts may mention BI Developer Extensions, BIDS Helper and Mist.

Create SSIS Project Parameters from Biml

Biml (Business Intelligence Markup Language) - Project Parameters from Biml

If you are using BIDS Helper or BimlExpress to generate SSIS packages in the Project Deployment model, you have probably noticed that it is not possible to create project parameters from Biml. You can write Biml for the project and project parameters, but BIDS Helper / BimlExpress will only generate the SSIS packages for you and not the SSIS project parameters. The recommended solution is that you create the project parameters manually before you generate your SSIS packages from Biml.

(Want to know why? Read Scott Currie’s explanation in my blog post Why can’t I create SSIS Project Parameters from Biml?)

However, if you are a lazy developer like me, you probably don’t want to create and update project parameters manually. Perhaps you want to automatically create or update project parameters based on some metadata? You can do that!

Let’s take a look at a (semi-hardcoded, semi-hack) solution for creating SSIS project parameters from Biml in BIDS Helper / BimlExpress :)

Continue reading →

Published: Last Updated: Categories: BimlTags: ,

Import Metadata in Biml using GetDatabaseSchema

Import Metadata in Biml using GetDatabaseSchema

One of the main tasks in Biml projects is to import source metadata. The recommended method is GetDatabaseSchema. This method returns an ImportResults object that contains SchemaNodes (schema metadata) and TableNodes (table and view metadata).

Continue reading →

Published: Last Updated: Categories: BimlTags:

Become a BimlHero Certified Expert

BimlHero Certified Expert

Continuing my “2015 is such an exciting year for everyone using Biml” trend, Varigence recently announced the BimlHero Certified Expert Program. This is an extensive certification program that will ensure that you have the skills and knowledge to implement advanced, automated Business Intelligence and Data Warehouse solutions using Biml, BimlScript and Mist.

…and it sure won’t be easy!

To become a BimlHero, you will need to have at least one year experience using SQL Server Integration Services (SSIS) and Biml. If and when Varigence accepts you into the program, you must first attend an 8-hour advanced training class. Within six months of attending the training class you must pass a BimlHero Certified Expert Test, and finally submit a complete production-quality Biml solution as well as a case study of a real-world Biml project you implemented. Varigence will review and provide feedback on the code sample and case study, and if they approve it… Congratulations, you will become a BimlHero Certified Expert! Simple as that :)

Read all about the program in Varigence’s BimlHero blog post and in the BimlHero program guide.

The first BimlHero training class will be held on April 29th in Copenhagen, Denmark during the Biml Scandinavian Tour 2015. Training classes will mainly take place in the US (Greenville, South Carolina) and Australia (Sydney), and online training options will be available in the future for those who are unable to travel.

Having the first training class in my region is a unique opportunity that I couldn’t miss! I will attend the training class in Copenhagen and then spend the next six months working on improving my Biml and BimlScript skills by teaching my coworkers and working with them on our Biml projects. (And I’m sure that by summer my coworkers will be teaching me lots of new tricks!)

It is truly exciting, and very terrifying, to be part of the first group of people who will attempt the BimlHero certification. It sure won’t be easy and there is always that risk of failing, but I will do my best, work hard, and have lots of fun with this awesome technology.

Are you in? :)