SQL Server Integration Services (SSIS) has been a cornerstone of enterprise data integration for decades, powering mission-critical ETL workloads across thousands of organizations worldwide. Now Invoke SSIS Package activity (Preview) in Data Factory in Microsoft Fabric, brings the power of your existing SSIS investments directly into Fabric's unified SaaS analytics platform.
Many enterprises have significant investments in SSIS packages that orchestrate complex ETL workflows across on-premises databases, file systems, and cloud services. Until now, running these packages required either an on-premises SQL Server or the Azure-SSIS Integration Runtime in Azure Data Factory. Both options meant managing additional infrastructure and staying outside the Fabric ecosystem.
But the Invoke SSIS Package pipeline activity in Microsoft Fabric Data Factory changes this. It allows you to execute your existing SSIS packages directly from a Fabric pipeline, enabling true lift-and-shift of legacy ETL workloads into Fabric — no package rewrite required. No integration runtime management, no stop/starting IRs— just add it to your pipeline!
Key benefits include:
- Zero rewrite migration: Run your existing SSIS packages as-is inside Fabric pipelines. Protect years of ETL investment while moving to a modern platform.
- Unified orchestration: Combine SSIS package execution with Fabric-native activities — Copy activity, Dataflow Gen2, Notebook, Stored Procedure, and more — in a single pipeline.
- OneLake integration: SSIS packages running in Fabric can leverage OneLake as package store and write package execution logs into OneLake.
- Simplified management: No need to provision or manage separate integration runtimes. Fabric handles the compute for executing your SSIS packages.
Getting started
Getting started with the Invoke SSIS Package activity takes just a few steps:
- Upload packages to OneLake — Move your .dtsx (and optional .dtsConfig) files into a Lakehouse via OneLake file explorer or the Fabric portal.
- Add the activity to a pipeline — Create or open a new pipeline, then add the Invoke SSIS Package activity from the Activities pane.
Figure: Add an Invoke SSIS Package activity.
- Configure package settings — Browse to select your package and configuration files from OneLake and optionally enable logging to capture execution logs in OneLake.
Figure: Invoke SSIS package activity configuration.
- Set runtime values — Override connection manager properties or package properties (such as connection strings and credentials) using the Connection Managers and Property Overrides tabs. You can use expressions, pipeline parameters, or system variables for dynamic values.
- Run or schedule — Save the pipeline and run it immediately or set up a recurring schedule.
- Monitor execution — Track progress in the pipeline Output tab or the workspace Monitor hub. When logging is enabled, detailed execution logs are written to OneLake.
For full configuration details, refer to the Invoke SSIS Package activity documentation.
Get started
The Invoke SSIS Package activity (Preview) for all Fabric workspaces.
- Open Data Factory in Microsoft Fabric.
- Create a new Data Pipeline in your workspace.
- Add the Invoke SSIS Package activity and configure it to point to your packages in OneLake.
- Refer to the Invoke SSIS Package activity documentation for detailed configuration guidance.
- Refer to Tutorial: Integrate SSIS with SQL database in Microsoft Fabric for detailed configuration to connect with Fabric SQL database in SSIS package.
We want to hear from you! Share your experience, report issues, and request features.
What's next
This preview represents the first step in a broader set of capabilities we’re building. Today’s experience focuses on core scenarios, with additional investments already underway — including expanded package sources, on-premises and private network connectivity, and custom or third-party component support. We’ll continue to evolve the platform as we incorporate feedback and deliver these capabilities over time.
These upcoming features will roll out through a series of private previews. If you'd like early access to help shape the future of SSIS in Fabric, sign up to join our upcoming private previews. Your feedback is invaluable in driving this experience toward general availability.
Learn more
Microsoft