Description
You’re watching data engineering shift under your feet. Azure Data Factory pipelines you spent years stabilizing are being flagged for migration to Fabric. SSIS packages that still pay the bills feel increasingly marooned.
Then last month at FabCon Atlanta, Microsoft announced the Invoke SSIS Package activity (Preview) in Fabric Data Factory. Your .dtsx files can now run natively inside Fabric pipelines. No rewrite. No Azure-SSIS Integration Runtime to manage. Lift and shift, with the SSIS logic intact.
That changes the migration conversation. It does not end it.
This one-day course is built for SSIS and ADF practitioners and those who desire to become Fabric Data Factory data engineers. The material is framed around migration — what carries over from SSIS and Azure Data Factory, what doesn’t, and what the new preview changes. If you’ve shipped production pipelines in either, the framing lands directly. Newer to data integration? You can absolutely follow the pace; the legacy-context framing is useful background for when you meet those decisions later.
Software engineering solved the “how do I learn a new platform in a week without breaking production” problem years ago. Data integration mostly didn’t. We’re fixing that here.
By 4:30 PM on 19 May, you’ll:
- Understand what the new Invoke SSIS Package activity (Preview) actually does, its current preview limitations, and when to use it versus keeping Azure-SSIS IR
- Understand exactly what carries over from ADF to Fabric Data Factory, and what doesn’t
- Have working patterns for copy operations, parameterization, and metadata-driven design
- Know when preview activities (Outlook, Teams) help and when they’ll bite you
- Have a clear mental model for loops, iteration, and conditionals in Fabric
- Understand Git integration for Fabric Data Factory as it actually works today
- Know how to monitor, debug, and troubleshoot production pipelines
- Have approaches for interacting with on-premises data from Fabric
- Understand where execution frameworks fit – and where they don’t
- See how ADF-in-Fabric works and when it’s the right bridge
About your instructor
Andy Leonard is the author of multiple books on SQL Server Integration Services, architect of the SSIS Framework orchestration model, and founder of DILM Suite. He’s been building, teaching, and writing about Microsoft data integration for more than two decades. His work runs in production at Fortune 500 enterprises, and he currently advises teams navigating SSIS-to-Fabric migration.
Questions people ask
Can I attend if I can’t make it live? Yes. Registered attendees receive the full recording within 48 hours and retain access for 90 days. Live attendance is recommended for Q&A but not required.
What’s the prerequisite level? Working familiarity with either SSIS or Azure Data Factory. If you’ve built production pipelines in either, you’re ready. No Fabric experience required.
Will we write code? This is a lecture-and-demo course. I work through live examples on a Fabric tenant, and attendees are encouraged to follow along if they have a Fabric-capable environment available (trial is fine). No hands-on labs, no coding exercises – the day is designed to build a working mental model, not burn hours in setup issues.
How does Q&A work? Live in Teams throughout the day, with a longer Q&A block at the end.
To attend this course, please install Microsoft Teams.
