The good people who work on Azure Data Factory recently added an Execute SSIS Package activity. It’s pretty cool. Let’s tinker with it some, shall we? First, you will need to create an Azure Data Factory SSIS Integration Runtime. If you don’t know how, that’s ok – I’ve written a post titled Lift and Shift SSIS …
Continue reading ADF Execute SSIS Package Activity
Category:SSIS Catalog Browser
Lift and Shift SSIS Part 1: Deploy Integration Runtime SSIS
What if I told you, “You can quickly and easily deploy Integration Runtime SSIS projects to Azure Data Factory?” You can! As shown in the image, you can simply right-click the SSIS project name in SQL Server Data Tools (SSDT) Solution Explorer and click Deploy to deploy the project to the Azure Data Factory (ADF) …
Continue reading Lift and Shift SSIS Part 1: Deploy Integration Runtime SSIS
Two Recordings Available: SSIS Catalog and SSIS Lifecycle
Andy Leonard shares two recordings about using the SSIS Catalog to manage enterprise data engineering.
Catalog Browser, Version 0.6.2.0
If you’ve read this blog for a short time, you already know I have a passion for DevOps. You probably guessed I also have a passion for data engineering (My job title at Enterprise Data & Analytics is Chief Data Engineer). I believe successful software development is a combination of a software development platform, a …
Continue reading Catalog Browser, Version 0.6.2.0
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
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 :{>
Presenting DevOps for SSIS 08 Feb 2018
I am honored to present DevOps for SSIS (or Data Integration Lifecycle Management) for the PASS DevOps Virtual Chapter 08 Feb 2018. Abstract: DevOps for SSIS (or Data Integration Lifecycle Management) How does SSIS participate in enterprise DevOps? Sharing topics from his latest book (Data Integration Life Cycle Management with SSIS), author and presenter Andy …
Continue reading Presenting DevOps for SSIS 08 Feb 2018
Updates to SSIS Catalog Browser
I’m happy to announce the release of Catalog Browser v0.5! I taught the app a new trick: viewing SSIS Catalogs in Azure! Of course, Catalog Browser still works locally: As the next release of SSIS Catalog Compare approaches, I’ve been testing – a lot. Catalog Browser shares quite a bit of functionality with Catalog Compare – …
Continue reading Updates to SSIS Catalog Browser
Upcoming Catalog Properties Update for SSIS Catalog Compare
In this video I share and discuss upcoming updates to SSIS Catalog Compare‘s Catalog Properties node. Check it out! :{>
Why I Built DILM Suite, by Andy Leonard
The following is Chapter 6: Catalog Browser from my latest book titled Data Integration Life Cycle Management with SSIS: A Short Introduction by Example: I was honored to be a Microsoft SQL Server MVP for five years (2007-2012). One cool thing about a being a Microsoft MVP was access to the internal developer teams. Everyone could …
Continue reading Why I Built DILM Suite, by Andy Leonard