I simply can’t express how excited I am about Biml (Business Intelligence Markup Language). In a nutshell, Biml is an XML like language that let’s you describe how an SSIS package (or packages) should look and the code then builds the SSIS package(s) for you. It’s magic. It’s a force multiplier. If you aren’t at least looking at how to bring Biml into your SSIS work already you will soon be left behind. Yeah … it’s kinda a big deal.
Rather than reinvent the wheel, in this first post on Biml for Brindle Solutions I decided to share my favorite resources to help you get started with Biml. They are in no particular order, I recommend you work through ALL of them.
Tim’s GO TO Biml resources
- Introduction to Business Intelligence Markup Language (BIML) for SSIS
- Increase your SSIS productivity with Biml (a little older but still one of my all time favorite Biml vids available online via The Great One (Reeves Smith FTW!)
- Cathrine Wilhemsen.net: Biml (Cathrine is amazing, she consistently posts the best Biml writing on the web.)
- the Stairway to Biml
- Dave Stein: Made2Mentor.com (Dave elevates Biml to a sublime form of art)
- Andy Leonard.com (the godfather of Biml, the data philosopher)
- Andy Leonard: One learning path for Biml
- Andy Leonard: dilmsuite.com (must have tools and frameworks for serious Biml)
- the Biml Book (Soup to nuts Biml, simply the best and most comprehensive look at the language available today.)
If you prefer hands on training to learn (or master) Biml, here are the folks I would (and do) go to.
Hands on training
so there you have it. I hope these lists help you get started. I know I’ve missed a LOT of great resources here, that’s where YOU come in. Drop me a comment and I’ll compile them into a follow up post!
My thoughts on Biml are lot less technical and granular. Biml, to me, is like a better mouse trap. You know all that super repetitive, prone to typos, tedious work you always thought there HAD to be a better more efficient way to do? Biml is that better more efficient way. SHHHH…don’t tell anyone about it. Just let them think you have recently become the fastest rockstar coder ever.Lori’s Two Cents