When Boris (@brshristov) invited me to a #SQLHangout I was really honored and couldn’t say no. It’s such a fun idea and I’ve really enjoyed watching the other #SQLHangouts. It’s great to see people’s personalities shine through in videos instead of only reading their blog posts, and I learn something new.
I suggested to chat about Biml, something I’ve only recently begun learning myself that has already saved me many hours of work. I still have so much to learn, but the fact that it took me about 20 hours to learn something new that has saved me and my coworkers hundreds of hours already… That’s worth sharing. If I can do it, you can do it!
Boris named the video “Biml. An introduction.” I thought a more appropriate name was “Blabbering about Biml” :)
I forgot to mention their names, but thank you to Julie Smith (@JulieChix) and André Kamman (@AndreKamman) for inspiring me to learn more Biml in their SQLSaturday sessions in Tampa and Copenhagen! :)
At work we wanted to start using Biml to speed up development in our existing projects without making too many changes at once. I decided to start by writing Biml files that generates SSIS packages exactly like the ones we already have so we can implement changes faster, and step one was to figure out how to create Package Configurations and Connection Managers in Biml:
Create an XML configuration file Package Configuration
Create the Connection Manager specified in the XML configuration file
Create SQL Server Package Configurations that use the Connection Manager specified in the XML configuration file
Create Connection Managers specified in the [SSIS Configurations] table in SQL Server
This post was first published in May 2014, is updated regularly, and was last updated in April 2019.
The table below is a simplified mapping between SQL Server, SSIS and Biml Data Types. It does not include all possible mappings or all data types, but is meant as a quick reference while developing and learning Biml. I mainly created it as a cheat sheet for myself, but I hope other Biml developers will find it useful!
From May 5th to May 15th Varigence and Rehfeld will visit six cities in four different countries to present Biml and Mist. The highlights of the tour are the four full day Biml Master Classes in each country. The classes will be taught by Scott Currie, the creator of Biml, and Rehfeld Principal BI Architect Peter Hansen.
SQL Server User Group Norway is happy to announce a Biml techie meetup for our members on Monday May 12th! Join us for a technically oriented introduction to Biml and a presentation on the use of Biml and auto generation of ETL in one of the biggest data warehousing development projects currently running in Denmark.