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
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
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
The Recording for Introduction to DILM is Available
A big ol’ Farmville Virginia THANK YOU to everyone who attended my free webinar Introduction to DILM on 1 Mar 2018! The recording is now available (registration required). The next free webinar is Introduction to SSIS Design Patterns, Part 1 8 Mar 2018 at noon ET. I hope to see you there! Register today. Learn …
Continue reading The Recording for Introduction to DILM is Available
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
Free Webinar – Win a Free Book! Introduction to DILM 1 Mar 2018
Join me 1 Mar 2018 at noon ET for Introduction to DILM – a free webinar in which we explore Data Integration Lifecycle Management using SSIS as an example. One attendee will score an autographed copy copy of my latest book, Data Integration Life Cycle Management with SSIS! You must be present to win. In the …
Continue reading Free Webinar – Win a Free Book! Introduction to DILM 1 Mar 2018
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 (andy.leonard@dilmsuite.com) 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