SSIS Catalog Browser is a pretty neat product. “How neat is it, Andy?” I’m glad you asked. It’s free. That makes it difficult to beat the cost. SSIS Catalog Browser is designed to surface all SSIS Catalog artifacts and properties in a single view. “What exactly does that mean, Andy?” You’re sharp. Let’s talk about why …
Continue reading Viewing SSIS Configurations Metadata in SSIS Catalog Browser
Category:DILM Suite
Viewing SSIS Configurations Metadata in SSMS
Let’s take a look at an SSIS Project in SSMS: Demo is the SSIS Catalog folder. Demo contains three SSIS projects named 0-Monolith, EmptySSISProject, and LiftAndShift. If we expand the LiftAndShift SSIS project we see it contains a single SSIS package named Load Customer.dtsx. The Demo folder contains two Catalog environments named env1 and env2. These …
Continue reading Viewing SSIS Configurations Metadata in SSMS
The Recording for Using SSIS Framework Community Edition is Available
The recording of my free webinar titled Using SSIS Framework Community Edition is now available (registration required). You can obtain the free and open source SSIS Framework Community Edition at DILM Suite. Enjoy! :{>
Free Stuff for People Who Give Back: Announcing 2019 Scholarships
Do you work for a charity or non-profit organization? Submit your application today. I haven’t advertised this in the past and… I’m not sure why: I donate licenses for SSIS Catalog Compare and (non-free) SSIS Framework Editions – and subscriptions to Biml Academy and SSIS Academy – and Enterprise Data & Analytics Training – to individuals who …
Continue reading Free Stuff for People Who Give Back: Announcing 2019 Scholarships
Using SSIS Framework Community Edition Webinar 20 Sep
Join me 20 Sep 2018 at noon ET for a free webinar titled Using SSIS Framework Community Edition! Abstract SSIS Framework Community Edition is free and open source. You may know can use SSIS Framework Community Edition to execute a collection of SSIS packages using a call to a single stored procedure passing a single …
Continue reading Using SSIS Framework Community Edition Webinar 20 Sep
Introducing Azure Data Factory Design Patterns
I was honored to write an article titled Introducing Azure Data Factory Design Patterns featured in this month’s PASS Insights newsletter! Introducing Azure Data Factory Design Patterns The article covers a couple execution patterns: Execute Child Pipeline Execute Child SSIS Package I demonstrate a cool SSIS Catalog Browser feature that helps ADF developers configure the Execute SSIS Package activity. To …
Continue reading Introducing Azure Data Factory Design Patterns
Announcing the Fundamentals of Azure Data Factory Course!
I am excited to announce a brand new course (it still has that new course smell) from Brent Ozar Unlimited and honored to deliver it! This one-day, live, online course is titled Fundamentals of Azure Data Factory and it’s designed to introduce you to Azure Data Factory (ADF). There will be demos. Live demos. Lots …
Continue reading Announcing the Fundamentals of Azure Data Factory Course!
Enterprise Data & Analytics and Andy Leonard Consulting
I occasionally get questions about my companies (yes, plural) so I thought I’d write a post explaining them. Enterprise Data & Analytics Enterprise Data & Analytics is a boutique consulting firm. I own the company and I also deliver consulting services. We have a team of experienced engineers who deliver everything from cloud data migrations to …
Continue reading Enterprise Data & Analytics and Andy Leonard Consulting
SSIS Catalog Compare Documentation is Available
I’m excited to announce the availability of SSIS Catalog Compare Documentation! And now, it’s free!
Anatomy of a Catalog Reference Script in SSIS Catalog Compare
A Catalog Reference script is automatically generated from several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Header Documentation The script begins with a header documentation similar to that shown here: When executed, the Project Reference script header documentation portion displays in the Messages output window of SQL Server management Studio (SSMS): The statements …
Continue reading Anatomy of a Catalog Reference Script in SSIS Catalog Compare