Skip to content

Biml Resources and References

On this page, you will find my collection of Biml resources and references, blog posts, presentations, videos, and slide decks 🤓

Demo Files

Cathrine Wilhelmsen’s Biml Demo Files

Blog Posts

SQL Server, SSIS and Biml Data Types
Get started with BimlExpress
Create your own BimlExpress Keyboard Shortcuts
Import Metadata in Biml using GetDatabaseSchema
Generating SQL using Biml
Generating SELECT statements in Biml using GetColumnList
Don’t Repeat Your Biml - Tiered Biml Files
Don’t Repeat Your Biml - Include Files
Don’t Repeat Your Biml - CallBimlScript with Parameters
Don’t Repeat Your Biml - C#/VB Code Files
Don’t Repeat Your Biml - C# Extension Methods
Biml Annotations and ObjectTags
Package Configurations and Connection Managers in Biml
Create SSIS Project Parameters from Biml
Why can’t I create SSIS Project Parameters from Biml?

These are my key blog posts. I regularly remove outdated blog posts, such as posts about older products or specific releases. You can find the full archive of my Biml blog posts by browsing the Biml category.

Presentation Recordings and Slide Decks

Biml for Beginners

Are you tired of creating and updating the same SSIS packages over and over and over again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and start automating your SSIS development?

Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!

Level Up Your Biml

Is your Biml solution starting to remind you of a bowl of tangled spaghetti code? Good! That means you are solving real problems while saving a lot of time. The next step is to make sure that your solution does not grow too complex and confusing - you do not want to waste all that saved time on future maintenance.

Start improving your code today and level up your Biml in no time!

Biml Tips and Tricks

“Wait, what? Biml is not just for generating SSIS packages?”

Absolutely not! Come and see how you can use Biml (Business Intelligence Markup Language) to save time and speed up other Data Warehouse development tasks. You can generate complex T-SQL statements with Biml instead of using dynamic SQL, create test data, and even populate static dimensions.

Don’t Repeat Yourself, start automating those boring, manual tasks today!

Podcasts and Hangouts

SQL Data Partners Podcast Episode 18: Biml (with Bill Fellows @billinkc)
SQLHangout #26: Biml in the Real World
SQLHangout #22: Biml

The Biml Book

Front cover of The Biml Book with all authors listed

Learn Business Intelligence Markup Language (Biml) for automating much of the repetitive, manual labor involved in data integration. We teach you how to build frameworks and use advanced Biml features to get more out of SQL Server Integration Services (SSIS), Transact-SQL (T-SQL), and SQL Server Analysis Services (SSAS) than you ever thought possible.

The Biml Book was co-authored by Andy Leonard (@AndyLeonard), Scott Currie (@scottcurrie), Jacob Alley, Martin Andersson (@frysdisken), Peter Avenant (@PeterAvenant), Bill Fellows (@billinkc), Simon Peck (@biguynz), Reeves Smith (@SQLReeves), Raymond Sondak (@raymondsondak), Ben Weissman (@bweissman) and Cathrine Wilhelmsen (hey, that’s me! 🤓)