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
Category:DILM Suite
Why I Built SSIS Framework Community Edition, by Andy Leonard
A few weeks ago I published a blog post titled Why I Built DILM Suite, by Andy Leonard – an excerpt from the book Data Integration Life Cycle Management with SSIS. Last week I published Why I Built SSIS Catalog Compare, by Andy Leonard, another excerpt from the book. This post is another excerpt of the same book. Enjoy! A …
Continue reading Why I Built SSIS Framework Community Edition, by Andy Leonard
Why I Built SSIS Catalog Compare, by Andy Leonard
A few weeks ago I published a blog post titled Why I Built DILM Suite, by Andy Leonard – an excerpt from the book Data Integration Life Cycle Management with SSIS. This post is another excerpt of the same book. In fact, this is the chapter that follows the chapter on Catalog Browser (which is …
Continue reading Why I Built SSIS Catalog Compare, by Andy Leonard
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!
SSIS Catalog Browser Video
Earlier today I went live on Facebook to share features of the latest update for SSIS Catalog Browser (which is FREE): What’s new? View Azure Data Factory version 2 Integration Runtime (aka SSIS in the Cloud) Values Everywhere Project Connections Project Connection References Package Connections Package Connection References :{>
Parallel Execution in SSIS Framework Community Edition
A number of folks are using the SSIS Framework Community Edition. I know because I continue to get interesting questions about it! Before I write more, I’d like to invite users to the DILM Suite Slack channel for Community Edition. If you cannot join, please let me know ([email protected]) and I will invite you! For …
Continue reading Parallel Execution in SSIS Framework Community Edition
SSIS Catalog Compare: Help for DBAs Who Support SSIS
In my SQL Server Central article, Help for DBAs Who Support SSIS, I walk through several DILM (Data Integration Lifecycle Management) use cases including: Surfacing SSIS Catalog metadata Comparing SSIS Project configurations in two SSIS Catalogs Scripting SSIS Project ISPAC files Deploying an SSIS Project from one SSIS Catalog directly to another SSIS Catalog Generating scripts …
Continue reading SSIS Catalog Compare: Help for DBAs Who Support SSIS
Presenting DevOps for SSIS 08 Feb 2018
I am honored to present DevOps for SSIS (or Data Integration Lifecycle Management) for the PASS DevOps Virtual Chapter 08 Feb 2018. Abstract: DevOps for SSIS (or Data Integration Lifecycle Management) How does SSIS participate in enterprise DevOps? Sharing topics from his latest book (Data Integration Life Cycle Management with SSIS), author and presenter Andy …
Continue reading Presenting DevOps for SSIS 08 Feb 2018
Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 3 – Execution, Monitoring, and Deployment Alternatives
In Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 1 – Build an ADFv2 IR Instance I wrote about the three steps to configure Azure-SSIS Integration Runtime in Azure Data Factory Version 2 (ADFv2 IR, or SSIS in the cloud). In Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 2 – Deploy, Execute, and Monitor an SSIS Project I wrote about deploying, …
Continue reading Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 3 – Execution, Monitoring, and Deployment Alternatives
Updates to SSIS Catalog Browser
I’m happy to announce the release of Catalog Browser v0.5! I taught the app a new trick: viewing SSIS Catalogs in Azure! Of course, Catalog Browser still works locally: As the next release of SSIS Catalog Compare approaches, I’ve been testing – a lot. Catalog Browser shares quite a bit of functionality with Catalog Compare – …
Continue reading Updates to SSIS Catalog Browser