← #15 MsBIP møde nr. 15, 23. oktober 2013

BIML and EzAPI – Two approaches to creating SSIS packages programmatically

Daniel Otykier (Kapacity)

In this talk, we are going to explore some of the benefits and drawbacks of creating SSIS packages from code. There are basically two practical approaches to this; BIML, which is an XML-based scripting language that integrates nicely with your existing SSIS solutions through BIDSHelper; and EzAPI, which is a C# library that makes it easy to build your packages from scratch in an object-oriented fashion. We will be looking at various samples for both approaches. BIML and EzAPI are valuable time-savers when it comes to repetitive tasks, such as extracting data from multiple tables. In addition, both allow you to build completely metadata-driven SSIS solutions that are very easy to maintain and extend. Lastly, we will provide references to online resources containing useful code snippets and samples. (This talk is intended for an SSIS-experienced audience. Programming experience is not necessary although some parts of the talk assume a basic understanding of programming concepts.)