The content in this post has been hidden by default because ImportDB will be deprecated in a future version of Biml. Use GetDatabaseSchema instead.
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:
I recommend reading Understanding Integration Services Package Configurations by Rafael Salas (b | t) and Getting Started with BimlScript by Paul S. Waters (t) if you’re not already familiar with the basics of SSIS Package Configurations and Biml.Continue reading →
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!
Can’t remember this post’s URL? Neither can I :) You can use this short URL instead: cathrinew.net/BimlDataTypes
(* These data types will be removed in a future version of SQL Server. Avoid using these data types in new projects, and try to change them in current projects.)Continue reading →