SQL Server Administration and Maintenance

SQT08 Advanced SSIS Package Authoring with Biml


3:15pm - 4:30pm

Level: Introductory to Intermediate

Tim Mitchell

Data Platform MVP


Tyleris Data Solutions

Have you ever needed to generate dozens (or even hundreds) of similar SSIS packages? Do you ever find yourself needing to regenerate a lot of packages when some piece of the upstream data format changes? Using native SSIS, this can be a tedious and error prone exercise.

However, using Biml (Business Intelligence Markup Language) can greatly increase your productivity as an ETL developer. In this session, we'll cover the essentials of Biml. I'll discuss what it is and what it can do for SSIS, demonstrating how it can easily generate dozens or even hundreds of packages in just a few minutes. I'll also demonstrate some realistic examples and discuss how Biml fits into the enterprise ETL picture.

Attendees will learn the essentials of Biml, including the basics of the language and how it fits into an SSIS environment; Attendees will learn how Biml can speed up SSIS development by eliminating much of the mundane work of building packages; Attendees will see several examples of how Biml can be used to automate package development.