Saving Your Biml Outputs

Kevin Feasel

2017-05-10

Biml

Tim Cost shows how to save the Biml which gets generated behind the scenes when you go to generate a set of files:

One of the first things I started wondering about as I got used to reading OPC (other peoples code) is just EXACTLY what is BIML doing at any given point in the code.  You can make some educated guesses based on the SSIS packages (in my case I’m exclusively interested in BIML for SSIS but of course it can do a lot more than that), but it’s easy to get lost, especially when there’s a lot of BIML script and some of it is only used to establish a data model in memory or to create / fill variables that will be used in SSIS.  I was delighted to discover the following piece of code that can show you exactly what BIML is doing based on the code you are writing.

If you don’t have BimlStudio, this trick is vital for figuring out what’s going wrong.

Related Posts

BimlExpress 2017

Cathrine Wilhelmsen alerts us to a new version of BimlExpress: .net intellisense Wait, what? .NET intellisense? Does that mean C# and VB intellisense? You bet it does! Now, let’s start with a small disclaimer. The release notes say: “Added preview mode of .NET intellisense for early adopters”. That means that this feature is not available out of the […]

Read More

Interactive CallBimlScript

Ben Weissman introduces a feature coming to BimlExpress: So far, there wasn’t much you could do but either replicate a lot of logic, parse the XML returned, use countless annotations or have many many different versions of your callee. All of these options aren’t too appealing, right? But: help is here! In addition to the […]

Read More

Categories