24 docs tagged with "BimlExpress"

Eight practical tips for working with Biml in Visual Studio, including editor settings, directive placement, escaping characters, and learning paths.

Documentation of how to add and edit files in BimlExpress

Documentation of BimlExpress accounts

Use the BimlExpress preview pane to see expanded Biml output without writing it to a file, including SQL output produced through code that uses GetDropAndCreateDdl.

Comparing BimlExpress and BimlStudio.

How a metadata-driven Biml project replaces hand-built SSIS templates and keeps every package aligned with a single ETL framework.

Use AllDefinedSuccessors at a high tier to apply a default property such as DefaultBufferMaxRows to every Dataflow Task in a project.

Use template Biml objects and a high tier merge file to push template columns and template events onto every other table or package in BimlExpress.

Move shared C# or VB logic out of Biml files and into external code files using the code directive so the same helpers can drive many projects.

Bind any BimlExpress command, such as Check Biml for Errors or Generate SSIS Packages, to a Visual Studio keyboard shortcut.

Generate the Project.params file for an SSIS Project Deployment model project from Biml by writing the parameter XML directly to disk during build.

Use ImportDB to materialize a SQL Server metadata schema as a DataSet inside BimlExpress, then drive connections, tables, and load packages from it.

An introduction to BimlExpress, the free Visual Studio add in for authoring Biml in SSIS projects, including installation, menus, and the code editor.

Use the Biml include directive to copy shared markup from one file into another so common variables, tasks, or fragments live in a single place.

How to install BimlExpress

Use CallBimlScriptWithOutput to return both Biml code and a dynamic object from a callee, so the caller can act on values produced inside the included script.

Explore menus and options

Explore how to preview the expanded BimlScript

Why BimlExpress and BI Developer Extensions do not generate SSIS project parameters out of the box, and the file safety reasons behind that decision.

Tour the building blocks of a Biml file: text blocks, directives, control blocks, and the RootNode that ties multiple files together across compile tiers.

Add file based logging to BimlScript executions inside BimlExpress by referencing the NLog assembly and writing structured messages to a log file.

Use the optionexplicit and optionstrict template attributes to write less verbose Visual Basic BimlScript when full type declarations are not needed.

Use a higher tier Biml file to capture the intermediate compiled XML produced after BimlScript expansion, making complex Biml files easier to debug.

An introduction to Biml and BimlScript covering what they are, why they exist, the tools that author them, the wider product ecosystem, and where Biml fits beyond SSIS.