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

Cathrine’s Biml content

Blog Posts

SQL Server, SSIS and Biml Data Types
Get started with BimlExpress
New Release: BimlExpress 2017!
Create your own BimlExpress Keyboard Shortcuts
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 – 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
Biml Annotations and ObjectTags
Package Configurations and Connection Managers in 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.

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

Official Biml Resources

Websites and Blog Posts
Download BimlExpress
BimlScript.com
BimlOnline.com
BimlScript.com External Content (Blog Directory)
BimlScript.com 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

Videos
BimlScript YouTube Channel
Varigence YouTube Channel

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

Videos
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)