Cathrine Wilhelmsen wrote a blog post with a mapping table (or cheat sheet) with the data types of SQL Server (DB), SSIS and Biml:
(you’re able to sort the columns on Cathrine’s post, just click on the link above)
The table below shows a simplified mapping between SQL Server, SSIS (SQL Server Integration Services) and Biml (Business Intelligence Markup Language) data types. The current version of the table does not include all type systems, all possible mappings or all data types, but is instead meant as a quick reference while developing and learning Biml. It was mainly made as a cheat sheet for myself, but I hope other new Biml developers will find it useful.