Author:Andy Leonard

The recording for Biml Academy 2 – Lesson 5 – Importing Data with Biml by Cathrine Wilhelmsen [Blog | @cathrinew] is now available! Cathrine did an outstanding job walking through several methods for importing database schemas using Biml. It’s worth a view (registration required). :{>

In May 2015 I wrote 700 – a post marking my 700th blog post here at SqlBlog.com. Last month I wrote Nine Years about another milestone here. Well, here we are in August 2016 and I’ve reached 800 posts! It’s an honor and privilege to write here. Here’s to the next 100 posts! :{>

Have you ever tried to move some (or all) of the contents of one SSIS Catalog to another? Deploying an SSIS Project to a different SSIS Catalog is straightforward: Execute the ISPAC file, configure the new SSIS Catalog as the target, click a few times, and Boom; done. What about the rest of it? I …
Continue reading Data Integration Lifecycle Management (DILM) with SSIS Catalog Compare: SSIS Catalog Environments

I am honored to be presenting at two upcoming SQL Saturdays, Spartanburg and Charlotte! In Spartanburg 20 Aug, I’m presenting: Using Biml as an SSIS Design Patterns Engine Use Biml to Automate SSIS Design Patterns Together, these two presentations an introduction to Business Intelligence Markup Language (Biml) and advanced-level application. In Charlotte 17 Sep, I’m …
Continue reading Presenting at Spartanburg and Charlotte SQL Saturdays!

Biml Academy 2 – Lessons 5-9 – will be 15-19 Aug 2016. Each 1-hour session will begin at 1:00 PM EDT and will be recorded. Join Cathrine Wilhelmsen (blog), BimlHero and Microsoft Data Platform MVP, Scott Currie (creator of Biml and Mist), and me as we explore staging and loading data using SSIS packages generated …
Continue reading Announcing Biml Academy 2!

I’m excited to announce Richmond Code Camp is back! We’ve rebranded to RVA Code Camp and our next event is scheduled for 22 Oct 2016 at ECPI in Glen Allen, VA. At the time of this writing: Registration and the Call for Presentations are both open. We hope to see you there! :{> PS – …
Continue reading RVA (Richmond) Code Camp is Back!

Join Andy Leonard and Kent Bradshaw of Enterprise Data & Analytics 11 Aug 2016 at 1:00 PM EDT as we discuss and demonstrate strategies for loading medical data to the Microsoft Azure SQL DB with SQL Server Integration Services (SSIS). Register today! :{>

There are several ways to stop and executing SSIS package. If the package is executing in the SSIS Catalog, you can use the SSISDB.[catalog].stop_operation stored procedure. Stop_operation has one parameter – a bigint named @operation_id. You can execute the stored procedure thus: exec SSISDB.[catalog].stop_operation @operation_id = <operation_id>; You can obtain the operation_id of an executing …
Continue reading Stop an SSIS Package

Exactly nine years ago I published my very first post here at SQLBlog.com titled SSIS Design Pattern – Incremental Loads. At the time I wrote this post, the last page of my blog dashboard appeared as shown in the screenshot above. It shows the Incremental Loads Design Pattern post has received over 230,000 views in …
Continue reading Nine Years

I recently tried to use the SSISDB Upgrade Wizard to upgrade a restored SSISDB (backed up in an earlier version) to SQL Server 2016. It didn’t go well. I decided to use SSIS Catalog Compare to generate the scripts and ISPAC files from the previous instance, and deploy them to the SSIS 2016 Catalog. “You …
Continue reading Use Catalog Compare to Migrate to the SSIS 2016 Catalog