Biml is growing in popularity and it’s so cool to be a part of this awesome and growing community! This is not an exhaustive list, but here are some places you can go to learn and read more about Biml:
Resources
Bloggers
Notes: I compiled this list from memory and by searching for blogs that have posted more than once about Biml. Plus, stuff I just found interesting and Biml-related. Bloggers are listed in alphabetical order.
If you blog about Biml or know of a Biml resource I left off this list, please email me using the link to the right. My intention is to edit this post to keep it relevant as our Biml Community grows!
:{>
…because what complex process couldn’t be simplified by adding a layer of XML to the mix?
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.
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