Join me Thursday, 07 Jun at noon EDT for a free webinar: Introduction to the SSIS Lifecycle! How should an enterprise promote SSIS projects from Development to Production? How many “levels” are required? What are the best practices? Do SSIS lifecycle management tools exist? Join Andy Leonard – SSIS author, trainer, and consultant – to …
Continue reading Introduction to the SSIS Lifecycle – 7 Jun 2018
Category:SSIS Catalog
Introduction to Configuring SSIS in the SSIS Catalog – 24 May 2018
Join me Thursday, 24 May for a free webinar: Introduction to Configuring SSIS in the SSIS Catalog! The SSIS Catalog is a flexible data integration framework. What’s wrong with that last sentence? “Flexible” is dual-edged – it means there’s some complexity. Fear not! Andy Leonard – SSIS author, trainer, and consultant – is here to …
Continue reading Introduction to Configuring SSIS in the SSIS Catalog – 24 May 2018
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
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 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
Honored to Present an SSIS and ADF Precon at Data Platform Summit 2018!
I am honored to announce I have been selected to deliver a full-day precon titled A Day of Intelligent Data Integration with SSIS and ADF at the Data Platform Summit 2018 in Bengarulu, India 7 Aug 2018! This will be my first appearance at the Data Platform Summit and my first visit to India. I …
Continue reading Honored to Present an SSIS and ADF Precon at Data Platform Summit 2018!
Free Webinar: Introduction to SSIS – 15 Feb 2018
Join me Thursday 15 Feb 2018 at noon ET for Introduction to SSIS – a free webinar from Enterprise Data & Analytics. Abstract: Join SSIS author Andy Leonard as he presents Introduction to SSIS! In this webinar, Andy covers the following topics: – Build your first SSIS package, a data warehouse ETL stage loader – Deploy …
Continue reading Free Webinar: Introduction to SSIS – 15 Feb 2018
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
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