Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

chugu
‎03-25-2026 09:00 AM

Invoke SSIS Package Activity in Microsoft Fabric (Preview)

If you haven’t already, check out Arun Ulag’s hero blog “FabCon and SQLCon 2026: Unifying databases and Fabric on a single, complete platform” for a complete look at all of our FabCon and SQLCon announcements across both Fabric and our database offerings. 

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:
  1. Upload packages to OneLake — Move your .dtsx (and optional .dtsConfig) files into a Lakehouse via OneLake file explorer or the Fabric portal.
  2. Add the activity to a pipeline — Create or open a new pipeline, then add the Invoke SSIS Package activity from the Activities pane.
Screenshot_of_pipeline_canvas_select_the_Invoke_SSIS_Package_Preview_from_the_drScreenshot_of_pipeline_canvas_select_the_Invoke_SSIS_Package_Preview_from_the_dr

Figure: Add an Invoke SSIS Package activity.

3. Configure package settings — Browse to select your package and configuration files from OneLake and optionally enable logging to capture execution logs in OneLake.

Screenshot_of_Invoke_SSIS_package_activity_configuration._It_shows_options_for_cScreenshot_of_Invoke_SSIS_package_activity_configuration._It_shows_options_for_c

Figure: Invoke SSIS package activity configuration.

4. 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.

5. Run or schedule — Save the pipeline and run it immediately or set up a recurring schedule.

6. 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.

Common Scenarios

Scenario 1: Lift and Shift from Azure Data Factory

If you are currently using the Azure-SSIS Integration Runtime in Azure Data Factory, you can migrate your SSIS orchestration to Fabric pipelines. This consolidates your data integration into Fabric while preserving your existing SSIS logic. Simply recreate your ADF pipeline in Fabric, replacing the Execute SSIS Package activity with the Invoke SSIS Package activity, and point it to the same SSISDB catalog.

Scenario 2: Hybrid ETL Orchestration

Combine SSIS packages with Fabric-native capabilities in a single pipeline.
  1. Use a Copy activity to ingest raw data from a cloud SaaS source into OneLake.
  2. Run an Invoke SSIS Package activity to apply complex transformation logic that already exists in your SSIS packages.
  3. Follow up with a Dataflow Gen2 activity for final data shaping before loading into a Fabric Data Warehouse.
This hybrid approach lets you modernize incrementally — converting SSIS packages to native Fabric activities at your own pace, while keeping everything running in production.

Get started

The Invoke SSIS Package activity (Preview) for all Fabric workspaces.
  1. Open Data Factory in Microsoft Fabric.
  2. Create a new Data Pipeline in your workspace.
  3. Add the Invoke SSIS Package activity and configure it to point to your packages in OneLake.
  4. Refer to the Invoke SSIS Package activity documentation for detailed configuration guidance.
We want to hear from you! Share your experience, report issues, and request features through the Fabric community or by reaching out to your Microsoft account team.

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

Labels: