Skip to main content

15 docs tagged with "bimlscript.com"

View all tags

Biml Metadata Starter Kit

A starter kit for creating BimlScript Metadata Driven packages using a Master Data Services back end to store the metadata.

BimlScript Intellisense with BimlExpress

BimlExpress for Visual Studio Code gives IntelliSense for Biml and for embedded C# and VB code nuggets. This page gives workarounds for the earlier BimlExpress add-in for Visual Studio, whose intellisense was limited to Biml only.

Copy All Data from Live Source Database

Connects directly to a live source database with 'ImportDB', then generates one Dataflow task per imported table that copies the data from the source connection to the target connection, with no advance knowledge of the source schema required.

Dynamic Biml Module Called with CallBimlScript

A parameterized child BimlScript (TableName, AuditTableName) that emits a per-table container with an Execute SQL task running a metadata-driven stored procedure plus an audit-log insert, called from a parent script via CallBimlScript to assemble fact and dimension load packages from metadata.

Setting Custom Error Handling Behavior

Demonstrates the 'ErrorHandling' element on a dataflow component, including how to set output-level 'ErrorRowDisposition' and 'TruncationRowDisposition' defaults and override them per column.

SHA1 Script Component Driven by Table Metadata

Imports a filtered list of AdventureWorks tables, then generates one per-table extract package whose script component reads each column's runtime DataType from the pipeline buffer, serializes the value (including null-handling tokens) into a byte array, and emits a SHA1 hash as a new output column.