THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

Announcing Biml Academy!

You can access Biml Academy recordings and more at the Biml Academy website!

Announcing Enterprise Data & Analytics Biml Academy – 5 Days of Free Training – 9-13 May!

Welcome to Biml Academy! Join me for a five-day online event and learn Biml now!

[Recording] Biml Academy – Lesson 0 – SSIS Design Patterns – Before we dive into code generation, let’s discuss and demonstrate some SSIS Design Patterns.
[Recording] Biml Academy – Lesson 1 – Build Your First SSIS Package with Biml – Learn how to build your an SSIS package using Biml.
[Recording] Biml Academy – Lesson 2 – Use Biml with SSIS Design Patterns – Learn how to use Biml with SSIS Design Patterns.
[Recording] Biml Academy – Lesson 3 – Use Biml to Build and Load a Staging Database – Learn how to build and load a staging database using Biml.
[Recording] Biml Academy – Lesson 4 – Automate SSIS Design Patterns with Biml to Load a Dimension – Learn how to automate SSIS Design Patterns with Biml to a load star schema dimension table.


I estimate each lesson will average 1 hour. 

The lessons will be recorded. 


Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Ray said:

Love it Andy,

Do you have an estimate of how long each Lesson will take?

March 31, 2016 9:36 AM

andyleonard said:

Hi Ray,

  Each lesson will last approximately one hour and they will be recorded. Sometimes the recordings fail...

  Hope to see you there!


March 31, 2016 6:22 PM

Erwin said:

Where can I find the recording of the first session?

May 10, 2016 6:33 AM

andyleonard said:

Hi Erwin,

  You can reach the recording here:

  I've updated the link above to point to the recording for Lesson 0. I plan to do that all week as the recordings go live.

Hope this helps,


May 10, 2016 11:46 AM

Erwin said:

Thank you. I've now downloaded 0 and 1. Can't wait for the other links :)

May 13, 2016 5:39 AM

Liling said:

Great contribution to the community! Thank you Excellent topic! But I don't know how to get the recordings?  

August 12, 2016 1:20 PM

andyleonard said:

Hi Liling,

  I broke the links when I made a change at Meeting Burner. I apologize. I've updated them and they should now work.

  Please let me know if that's not the case.

Thank you,


August 12, 2016 4:10 PM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement