Business Intelligence Markup Language

How To Contribute a Snippet

Demonstrates how to create a Snippet on BimlScript.com

How to Contribute a Walkthrough

Demonstrates how to create a Walkthrough on BimlScript.com

Getting Started with BimlScript - Part 1

Part 1: Learn to use BIDS Helper to create a Biml file, and then use it to generate a SSIS package in BIDS / SSDT.

Getting Started with BimlScript - Part 2

Part 2: Learn to create BimlScript by incorporating BimlScript code nuggets in a Biml file. These code blocks make it possible to auto-generate multiple packages, while conditionally adding tasks to some packages but not others.

Getting Started with BimlScript - Part 3

Part 3: Familiarizes the reader with BimlScript directives, which are used to control how BimlScripts are processed. The walkthrough also shows how template tiers let a Biml author control the order in which BimlScript files are processed.

Basic BimlScript Structure

The basic elements of a BimlScript file are covered.

How to Contribute a Walkthrough

Demonstrates how to create a Walkthrough on BimlScript.com

Overcoming BimlScript Copy and Paste Issues in Visual Studio

When a new Biml file is added to Visual Studio, the editor assumes that all of the code being entered is XML. Since BimlScript is not XML, the editor does not know how to handle it. This will show you have to remedy this issue.

Grabbing Twitter Data Using a ForEachAdoLoop and Biml

Modifying the code posted by John Minkjan, this walkthrough shows how to search Twitter for different terms by using a ForEachAdoLoop.

BimlScript Transformers Primer

5.17.13

An introduction on using of transformers in BimlScript - presently a feature only available in Mist.

Creating Script Task Projects inline

5.03.13

Biml supports the creation of a script project that can be referenced from multiple tasks/components. But sometimes, when writing automation code, you'd prefer to create the script projects inline with the project. This snippet shows how to do that for Script Tasks.

Package Parameters

5.01.13

This is a simple snippet that shows how to declare and reference package parameters in Biml for use with SSIS 2012.

Generating a list of Biml Scripts and Descriptions

3.28.13

A C# script that finds all .biml files in a directory and pulls the Description Summary annotation if available.

Using the Attunity Oracle Connector with Biml

3.05.13

Describes an end-to-end process for setting up Oracle XE and accessing data from SSIS using the Attunity Oracle Connection with Biml.

Incremental Load Design Pattern

2.06.13

The Incremental Load Design Pattern, taken from the book SSIS Design Patterns (http://www.amazon.com/SSIS-Design-Patterns-Matt-Masson/dp/1430237716).

Using the Union All component

1.03.13

Demo Biml using Union All component to combine error output and remove columns from the dataflow buffer that are not needed.

Using a Merge Task123

1.01.13

An explanation and example of the Merge task.

Disable indexes before dataflow and rebuild them afterwards

12.05.12

Before the dataflow every non-clustered index in the target table is disabled and after the dataflow every index is rebuild.