Biml Resources and References

The Biml Book

The Biml BookLearn 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) Upcoming Events
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

Cathrine’s Biml content

Blog Posts

Get started with BimlExpress
New Release: BimlExpress 2017!
Get started with BimlOnline Beta
SQL Server, SSIS and Biml Data Types
Create SSIS Project Parameters from Biml
Why can’t I create SSIS Project Parameters from Biml?
Biml Extension Methods: GetDatabaseSchema
Biml Extension Methods: ImportTableNodes and ImportDB
Don’t Repeat Your Biml – Include Files
Don’t Repeat Your Biml – CallBimlScript with Parameters
Don’t Repeat Your Biml – C#/VB Code Files
Package Configurations and Connection Managers in Biml
Develop in Editor Online or Offline
Biml updates in BIDS Helper 1.7.0 and Mist 4.0

Presentations and Demos

Download the .zip file with all my demos and scripts:
Cathrine Wilhelmsen’s Biml Demo Files





Podcasts and Hangouts

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

Great External Resources

Webinars and Courses

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

Create and Load a Staging Environment from Scratch in an Hour with Biml by Scott Currie (@ScottCurrie)

Scott Currie’s session from the Biml Scandinavian Tour 2014 by Scott Currie (@ScottCurrie)

Using Biml as an SSIS Design Patterns Engine by Andy Leonard (@AndyLeonard)

Biml – The Next Step in Agile Data Warehousing by David Stein (@Made2Mentor)