I had no sooner published my blog post about the coolness of Biml 2018 when I encountered a bug trying to use one of the features I really like – converting SSIS packages to Biml using (FREE!) BimlExpress 2018 with Visual Studio 2017. My first response was, “Durnit! This worked in the test versions.” My second …
Continue reading Workaround for BimlExpress 2018 Error Importing Packages
Category:Biml
It’s Biml 2018 Release Day!
Scott Currie and the team at Varigence announce the release of BimlFlex 2018, BimlStudio 2018, and BimlExpress 2018! This much-anticipated release includes awesome features for experienced Biml professionals as well as for data engineers new to automating processes! BimlFlex 2018 BimlFlex is a mature and complete data engineering automation framework. Out of the box, BimlFlex …
Continue reading It’s Biml 2018 Release Day!
My Books
I’ve authored and co-authored a bunch of books! Truth be told, I enjoy writing. I think my love of writing stems from a love of learning. I’m just trying to share the joy! It’s a huge honor to write. I’m humbled and thrilled (all at the same time – a feeling I describe as “all …
Continue reading My Books
Honored to Deliver Intelligent Data Integration – a PASS Summit 2018 Precon
I’m honored to deliver my full-day precon, Intelligent Data Integration with SSIS, at the PASS Summit 2018! You can see a list of other precons at the PASS Summit 2018 Pre-Conference Sessions page. I refer to this group as “a bunch of really smart people… plus me!” Abstract What is Intelligent Data Integration? SSIS (SQL Server …
Continue reading Honored to Deliver Intelligent Data Integration – a PASS Summit 2018 Precon
My Learning Resources for SSIS
People often ask me, “Andy, where can I learn SSIS or learn more about it?” Well, you’re at one such location – my blog! I’ve been blogging about SSIS for about 10 years as I type this. There’s a lot posts here about SSIS – that’s the good news. The bad news is: There’s a …
Continue reading My Learning Resources for SSIS
The Recording of Introduction to Biml is Available
The recording for Introduction to Biml is now available (registration required)! In this gentle introduction to Business intelligence Markup Language (Biml), author and BimlHero Andy Leonard walks through the basics of the Biml and BimlScript languages, demonstrating how to use Biml to generate several SSIS packages in minutes. Check out Introduction to Biml to learn …
Continue reading The Recording of Introduction to Biml is Available
Presenting Use Biml to Automate SSIS Design Patterns to MSDEVMTL!
I’m honored and excited to deliver Use Biml to Automate SSIS Design Patterns to the MSDevMTL User Group in Montréal, QC 27 Mar 2018! Session: Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS …
Continue reading Presenting Use Biml to Automate SSIS Design Patterns to MSDEVMTL!
Free Webinar: Introduction to Biml – 22 Feb 2018
Join me Thursday 22 Feb 2018 at noon ET for Introduction to Biml – a free webinar from Biml Academy. Abstract: Join Biml and SSIS author Andy Leonard as he presents Introduction to Biml! In this webinar, Andy covers the following topics: – Code your first Biml file in BimlExpress (free!) – Use BimlScript to automate …
Continue reading Free Webinar: Introduction to Biml – 22 Feb 2018
Biml Case Study: Automate an Extract for Patrick LeBlanc’s K12 Solution
My friend and brother, Patrick LeBlanc (@patrickdba), built a cool Power Bi Dashboard (and database!) to help K12 education systems track students and student activities such as attendance. Better yet, he gives it away! He gives away the code and he shares a free Guy in a Cube video walking through the features. Patrick emailed and …
Continue reading Biml Case Study: Automate an Extract for Patrick LeBlanc’s K12 Solution
The Next Book Project: Frameworks
Kent Bradshaw, Shannon Lowder, and I explore stored procedure-based data integration patterns, an SSIS execution framework, and two Biml frameworks in a book we are writing, tentatively titled Frameworks.