Do you use C#/VB classes and methods in your Biml projects? One solution is to create class nuggets <#+ … #>, but they can only be used in their containing Biml file. You can move class nuggets to separate files and include those files, but a more elegant solution is to use C#/VB Code Files.
In addition to using C#/VB Code Files, there are four other main ways you can avoid repeating your Biml code:
Is it March yet? I’m very happy to announce that I will be speaking at SQLSaturday Chicago 2016! A huge thank you to the organizers who selected my session :D
This will be my first trip in 2016, and I’m really looking forward to visiting a new city. It’s going to be a long trip for just a few days, but it will definitely be worth it!
On Saturday, March 5th, I will present my Biml for Beginners: Speed up your SSIS development session. It’s an introduction to Biml for those who are just starting to learn Biml. I have presented this session at a few events now, and I always find something to improve. Some content will be familiar for those who have seen my slide decks already, but I’m currently working on a few tweaks.
I will be available the whole day if you want to chat, have any Biml questions, or want me to go through some of the content from my more advanced Biml sessions. I’m slightly obsessed with the topic, and I’m happy to talk for hours if someone doesn’t stop me ;)
Take a look at the amazing schedule, register now so you don’t end up on a wait list, and join the conversation on Twitter by using the hashtag #SQLSatChi.
Are you using Biml so you won’t have to do the same tasks over and over and over again in multiple SSIS packages? If so, you probably don’t want to write the same Biml code over and over and over again either. Instead, you can move common code to separate files, centralize and reuse these files in many projects, and update code in one file to make changes to all projects. One of the ways to apply this Don’t Repeat Yourself software engineering principle in Biml is to use Include Files.
In addition to using Include Files, there are four other main ways you can avoid repeating your Biml code:
2015 was a year of highs and lows for me. I did so many things for the first time and really pushed myself out of my comfort zone. I made new friends and grew closer to old friends. At the same time I struggled more than ever with my old enemies depression, insomnia, migraine and impostor syndrome. All in all, I guess you can call it “life” :)
Yay, I’m so excited to finally share these news! Join Scott Currie (@ScottCurrie) and me for a Biml Training Day at SQLBits XV in Liverpool on May 4th: Learn Biml Today: Start Using It Tomorrow.
Biml Training Day at SQLBits XV
Scott and I will guide you through everything you need to start using Biml in real projects. From installing the free Biml tools, to the basics of Biml and BimlScript, to creating a staging environment, to building a metadata framework, and finally how to organize your code, work in a team, and automate deployment. Yep, that’s a lot of content to go through in one day, but you will get all the sample code so you won’t have to start from scratch.
We have very different backgrounds and experiences. Scott created Biml and I work in-house with teams in different countries. We will focus on best practices and code standards, but I’m also looking forward to sharing how we’ve solved problems in different ways. We hope the day will be interesting for everyone, from those of you who are completely new to Biml to those of you who have already built a Biml solution. Bring your questions and real-life problems! And if one day isn’t enough? I’ll be there for another three days :)