Wednesday, June 27, 2012

My First BIML

In BIDS right click on the solution and pres Add New Biml File

Give it a meaning full name and open the script:

Biml tries to follow the standard XML coventions so let's start with some comments:

Let's add a package:

The ConstraintMode indicates how the connections between elements are handeld by default.

Let's add some sequence containers:

 And tie them together:

Now generate the package:

Check the Content:

Till Next Time

Tuesday, June 26, 2012

BIML Introduction

For those of you who haven't met BIML yet..... BIML stands for Business Intelligence Markup Language. It's a powerful tool originally developed by the people of varigence for sricpting microsoft BI packages.
And the best thing is, they made it available with the BIDS Helper! In this Blog I will show you some examples on how it can simplify your life as a MS ETL developer.
I'm using 2008R2 and the BIDS helper 1.5.

Note: There seems to be an issue with the BIDS helper 1.6. The BIDS team is working on it!

Till Next Time

Monday, June 25, 2012

Welcome to BIML101

Here I will keep you posted on all my Business Intelligence Markup Language adventure's !

Till Next Time