Skip to content

Biml Resources and References

Demo Files

Cathrine Wilhelmsen’s Biml Demo Files

Blog Posts

SQL Server, SSIS and Biml Data Types
Get started with BimlExpress
New Release: BimlExpress 2019
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

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

The Biml Book

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! :))

Official Biml Resources

Websites and Blog Posts
Download BimlExpress External Content (Blog Directory)
Meet the BimlHeroes!
Quick References for Biml Extensions and Linq for C# (plus another 101 Linq Samples)

Social Networks
LinkedIn: Biml User Group
Twitter: #Biml
Twitter: @BimlScript

BimlScript YouTube Channel
Varigence YouTube Channel

Great External Resources

SQL Server Central: Stairway to Biml
Andy Leonard’s Biml and SSIS Content
Building Blocks of Biml by Stacia Varga on Pluralsight

Last Updated: