The SSIS Design Pattern known as the Controller Pattern provides a solution for executing SSIS packages in parallel – even from a serial SSIS execution framework such as SSIS Framework Community Edition (part of DILM Suite).
Category:Data Integration Patterns
You Might Need an SSIS Framework
You might need an SSIS framework. “How can I tell if I need an SSIS framework, Andy?” I’m glad you asked. Does your enterprise: Practice DevOps? Execute lots of SQL Server Integration Services (SSIS) packages? Execute SSIS packages several times per day? Execute “SSIS in the Cloud” using the Azure Data Factory version 2 Integration …
Continue reading You Might Need an SSIS Framework
Deploying to the SSIS Catalog Changes the Protection Level
I recently answered a question on the SQL Community Slack #ssis channel about SSIS and security. Let me begin by stating that SSIS security is complex, made up of many moving parts, and not trivial. If you struggle with SSIS security configuration, you are struggling with one of the harder parts of SSIS. Protection Level …
Continue reading Deploying to the SSIS Catalog Changes the Protection Level
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
Honored to Present Faster SSIS at SQL Saturday Albuquerque on Cinco de Mayo!
I am honored to present Faster SSIS at SQL Saturday #720 – Albuquerque 5 May 2018! Abstract Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages. We’ll start …
Continue reading Honored to Present Faster SSIS at SQL Saturday Albuquerque on Cinco de Mayo!
The Recording for Introduction to Loading the Cloud with SSIS is Now Available
The recording for the free webinar titled Introduction to Loading the Cloud with SSIS is now available (registration required). Abstract The cloud is coming, ready of not. In this session, presenter and author Andy Leonard discusses and demonstrates some patterns for loading cloud destinations using SSIS. For more information on data integration in the cloud, …
Continue reading The Recording for Introduction to Loading the Cloud with SSIS is Now Available
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
Introduction to Loading the Cloud with SSIS – 29 Mar 2018
The cloud is coming, ready of not. In this session, presenter and author Andy Leonard discusses and demonstrates some patterns for loading cloud destinations using SSIS. Join me for Introduction to Loading the Cloud with SSIS 29 Mar 2018 at noon ET to learn more. Register today! :{>
The Recording for Introduction to SSIS Design Patterns, Part 1 is Available
The Recording for Introduction to SSIS Design Patterns, Part 1 is now available (registration required). Abstract: SSIS Design Patterns are tried and true data integration patterns built in SQL Server Integration Services (SSIS). Join author and international speaker Andy Leonard as he explores: – The Truncate and Load Staging Pattern – The Incremental Load Pattern
Free Webinar – Introduction to Change Detection with SSIS 15 Mar 2018
Join me 15 Mar 2018 at noon ET for Introduction to Change Detection with SSIS, another free webinar sponsored by Enterprise Data & Analytics. Change detection is the central component for Incremental Load data integration patterns. In this presentation I discuss and demonstrate three change detection patterns: – No Change Detection – Brute-Force Change Detection …
Continue reading Free Webinar – Introduction to Change Detection with SSIS 15 Mar 2018