Save Time and Improve SSIS Quality with Biml

Target Audience:

“Save Time and Improve SSIS Quality with Biml” is completely introductory. The primary target audience for “Save Time and Improve SSIS Quality with Biml” is SSIS developers. DBAs are sometimes asked to build SSIS solutions, as are sysadmins and – rarely – managers.

Why do I include DBAs, sysadmins, and managers in my target audience?

Because good managers understand what’s possible, even (especially) if they cannot perform the work themselves.
Because sysadmins are sometimes tasked with anything and everything.
And because I know more DBAs who use SSIS than I know dedicated SSIS developers.


“Save Time and Improve SSIS Quality with Biml” introduces Business Intelligence Markup Language (Biml) to SSIS developers, DBAs, sysadmins, and others who want to learn more about automating SSIS development.

Automation (or code generation) improves the quality of SSIS solutions while saving time. With Biml, you can build lots of SSIS packages faster than building them manually. Because Biml generates SSIS packages from a template human error is mitigated. Therefore, the quality of the SSIS packages improves.

Why I Want to Present This Session:

Efficiency is the key to progress. If I can teach one person to more efficiently redeem their time, I’ve changed the world a little. If I change the world a little enough times, it will compound into a large change.

I’ve seen Biml reduce development time while improving code quality. That’s highly efficient.

People familiar with Biml may learn a new trick or tip.
People familiar with SSIS but not Biml may be encouraged to invest in learning Biml.
People who occasionally deliver SSIS (or manage or work with those that do) may realize there’s a way to deliver on an impossible deadline, delivering what would have taken months in SSDT manually in weeks using Biml.

Additional Resources:

Biml Academy

Stairway to Biml (SQL Server Central)

Andy’s Biml posts on

The following two tabs change content below.
Andy Leonard is Chief Data Engineer at Enterprise Data & Analytics, creator of the DILM (Data Integration Lifecycle Management) Suite, author / co-author of twelve books, technical trainer, blogger, dad, grandfather, and recovering chicken farmer.

Latest posts by Andy Leonard (see all)

Previous Post
Alleviating database consolidation pains
Next Post
SQL R Services: Start Working WITH Your Data Scientists

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.