Skip to main content

BimlScript Lessons

If you're new to Biml, start here. The lessons walk through Biml fundamentals, BimlScript automation, and end with a checkpoint project that puts everything together. Each lesson builds on the ones before it, and the map below shows the recommended path through the material.

Loading lesson map...
  1. What is Biml? — Overview, key concepts, and your first code example.
  2. C# Primer — Variables, LINQ, lambdas, and error handling for BimlScript automation.
  3. LINQ for BimlScript — Complete LINQ reference for metadata queries.
  4. Biml Tools — Choose the right tool (BimlStudio, BimlExpress, etc.).
  5. Automation and Patterns — Design principles for maintainable solutions.
  6. Intro to XML — XML fundamentals required for Biml.
  7. Biml Basics — Syntax, naming conventions, and object references.
  8. Biml Basics for Relational Databases — Connections, databases, tables, columns.
  9. Biml Basics for SSIS — Control flows, data flows, and transformations.
  10. Biml Basics for SSAS — Cubes, dimensions, tabular models, and processing automation.
  11. Techniques for Automating Biml Code — Alternative approaches (Excel, SQL, PowerShell).
  12. Introduction to BimlScript — Code nuggets, directives, and tiers.
  13. Using .NET Variables to Partially Automate BimlScript — Partial automation with variables.
  14. Using .NET Control Structures to Fully Automate BimlScript — Full automation with loops and conditions.
  15. Build Automated Staging Layer — End-to-end checkpoint project: a metadata-driven staging layer.