Biml Resources and References
On this page, you will find my collection of Biml resources and references, blog posts, presentations, videos, and slide decks 🤓
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
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! 🤓)