Tag Archives: BIML

Useful Tips in using BIML in BidsHelper

This is a follow up post on the first post my colleague and owner (Louw Fouche) of sabigdata, wrote around BIML and generating SSIS packages. This article will focus on some of the insights we gained using BIML for Source to … Continue reading

Posted in SQL Server 2012, SQL Server 2014 | Tagged , , , | Leave a comment

SQL Server data types in .Net Framework

The good folks at Microsoft did a wonderful job at providing us with a SQL Server data type mapping for the .Net Framework. This is especially useful when you are working with SSIS or have some BimlScript. I used it … Continue reading

Posted in SQL Server 2014 | Tagged , , , | Leave a comment

How to create a SSIS package using BIML

This is the first in a series of posts about Business Intelligence Markup Language (BIML). Today we will create a simple SSIS package called “Hello World”. (Yes, I know it is lame.) Below is the BIML code to generate a … Continue reading

Posted in SQL Server 2014 | Tagged | Leave a comment