These posts are about Biml (Business Intelligence Markup Language), BimlScript, BimlExpress, BimlStudio, BimlOnline, the BimlHero Certified Expert Program and events by the Biml community or Varigence. Older posts may mention BI Developer Extensions, BIDS Helper and Mist.
Are you interested in Biml and attending PASS Summit 2014? Join BI Over Beers (BIOB) at the Tap House Grill in Downtown Seattle on Monday, November 3rd from 6-9pm. You’ll have the opportunity to meet and talk with BI professionals from all over the world, and Varigence will provide food, drinks and even give-aways!
I’m very much looking forward to this, will I see you there? :)
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!