THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

So You Want to Learn More About Biml?

This blog has moved! You can find this content at the following new location:

Published Thursday, June 2, 2016 10:24 AM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



sqlblindman said:

...because what complex process couldn't be simplified by adding a layer of XML to the mix?

June 2, 2016 11:46 AM

Peter Schott said:

I think the main point for BIML isn't that you're adding a layer of XML, but you're writing code that you can more easily tweak to generate your SSIS packages. Ever had to adjust a package doing a bunch of inferred dimension member loads with a ton of UNION ALL transforms and realize that you need to add a new column to the mix? BIML - add the appropriate column and the code to add a new inferred member set. SSIS - repeatedly click to adjust each UNION ALL transform along the way.  We lost so much time to just this one case that had we been able to use BIML at the time, we would have considered it. (This was prior to BIML.)

Surprised that I made this list. My BIML experience is very limited, but I see the value in it. :) I knew of Catherine and Bill Fellows - have to check out a lot of the rest on the list.

June 6, 2016 2:57 PM

Shaun Ryan said:

It adds many things for me:

- greater visibility and efficient access to task and transformation properties

- code re-use at package level or below package level

- dynamic meta data driven etl creation - write once use forever. In fact the integation with .NET has allowed me to build advanced, automated and hihgly flexible frameworks

- easier upgrade or downgrade - the code doesn't require much tweaking just target a different version

June 7, 2016 2:08 AM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement