I love the SSIS Catalog. It’s an elegant piece of data integration engineering and I cannot say enough positive things about it. Packaging SSIS Catalog deployments can be tricky, though. The SSIS Catalog is a framework. Frameworks manage execution, configuration, and logging; and the SSIS Catalog handles each task with grace. Like I said, I …
Continue reading Packaging SSIS Catalog Deployments
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
PASS Summit 2018 Session Feedback
I was honored to participate in three presentations at the PASS Summit 2018. I delivered a full-day pre-conference session titled Intelligent Data Integration and another session titled Faster SSIS. I also participated on a panel titled BI & Data Visualization. A great big THANK YOU to everyone who attended my presentations! As I’ve shared (numerous …
Continue reading PASS Summit 2018 Session Feedback
Biml, Book Reviews, and Metadata-Driven Frameworks
I occasionally (rarely) read reviews at Amazon of books I’ve written. If I learn of a complaint regarding the book I often try to help. If a reader experiences difficulty with demos, I often offer to help, and sometimes I meet with readers to work through some difficulty related to the book (as I offered …
Continue reading Biml, Book Reviews, and Metadata-Driven Frameworks
Catalog Browser v0.7.8.0
I’ve been making smaller, more incremental changes to SSIS Catalog Browser – a free utility from the Data Integration Lifecycle Management suite (DILM Suite). You can use SSIS Catalog Browser to view SSIS Catalog contents on a unified surface. Catalog Browser works with SSIS Catalogs on-premises and Azure Data Factory SSIS Integration Runtime, or Azure SSIS. It’s …
Continue reading Catalog Browser v0.7.8.0
Two (or More) Kinds of Developers
I’ve made statements about “two kinds of developers” for years. These statements are false inasmuch as all generalizations are false. The statements are not designed to be truisms. They are designed to make people think. Last week – while presenting a full-day pre-conference session at the PASS Summit 2018 and again when delivering a session …
Continue reading Two (or More) Kinds of Developers
Want a Free #DILM Book? See Me at the #PASSsummit 2018!
I’ll be at the PASS Summit 2018 next week. I’m delivering a full-day precon Monday, presenting Faster SSIS and participating in the BI & Data Visualization Panel Wednesday, and Enterprise Data & Analytics is exhibiting Wednesday through Friday. “You Mentioned a Free Book…” Oh. Yeah. That. I will be giving away free copies of my latest book: Data Integration …
Continue reading Want a Free #DILM Book? See Me at the #PASSsummit 2018!
DILM Tiers for Enterprise Data Integration
“How many Data Integration Lifecycle Management tiers (DILM tiers) do I need to manage enterprise data integration, Andy?” If I had a nickel for every time I am asked this question, I would have a lot of nickels. My answer is, “Four.” Why Four? I’m glad you asked. Before I answer, I have a question …
Continue reading DILM Tiers for Enterprise Data Integration
SSIS Project Incompatible
Has this ever happened to you? You are opening an SSIS project and… it won’t open. Instead of a Control Flow filled with awesome tasks and containers, you see a message in Solution Explorer telling you “The application is not installed.” You know this isn’t right because you built the SSIS project on this same machine …
Continue reading SSIS Project Incompatible
Honored to Present Faster SSIS at Triad SQL PASS BI 30 Oct!
I am honored to join my friends at the Triad SQL PASS BI Group in Greensboro North Carolina 30 Oct 2018, where I will present Faster SSIS! Abstract Ever wonder why SSIS runs so slowly? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data, and shows you how to …
Continue reading Honored to Present Faster SSIS at Triad SQL PASS BI 30 Oct!
Stairway to Biml 9 is Live!
I am pleased to share Stairway to Biml 9 – Refactoring a Simple Custom Biml Framework is now live at SQL Server Central! Typing that, I realize I neglected to publicize the fact that two other Stairway to Biml articles were recently published at SQL Server Central: Stairway to Biml Level 7 – Populating the Database for …
Continue reading Stairway to Biml 9 is Live!