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 see it in action, download SSIS Catalog Browser – it’s one of the free utilities available at DILM Suite. Connect to the instance of Azure SQL DB that hosts an Azure Data Factory SSIS Integration Runtime Catalog, select the SSIS Package you desire to execute using the Execute SSIS Package activity, and then copy the Catalog Path from the Catalog Browser status message:
Paste that value into the Package Path property of the Execute SSIS Package activity:
You can rinse and repeat – Catalog Browser surfaces Environment paths as well:
Enjoy the article!
If you have any questions about Azure Data Factory – or need help getting started – please reach out!
Attend my full-day pre-conference session titled Intelligent Data Integration at the PASS Summit 2018 on 5 Nov 2018.
Check out this 1-day course on Fundamentals of Azure Data Factory delivered in cooperation with Brent Ozar Unlimited 10 Dec 2018!