Description
The Execute SSIS activity allows you to run SQL Server Integration Services (SSIS) packages within your workflow. SSIS is a powerful data integration tool used to move, transform, and cleanse data across systems.
This activity executes an SSIS package stored in SQL Server and returns the output for further workflow processing. Parameters can be passed to dynamically configure the package during runtime.
Use Case:
Use this activity when you want to reuse your existing ETL logic built in SSIS from within a modern workflow — for example, moving data from OLTP to a warehouse or applying business rule transformations.
| Type | Description |
|---|
| File | SSIS package configuration |
Output
| Type | Format | Description |
|---|
| Execution Data | Table | Output generated from the executed SSIS task |
Configuration Fields
| Field Name | Required | Description |
|---|
| Connection | Yes | Connection settings for SQL Server with SSIS access. |
| Package | Yes | Name of the SSIS package to execute from the configured catalog or folder. |
| Params | No | Key-value pairs for package parameters (if required). |
Not applicable — the package is retrieved and executed directly via the provided connection.
Sample Configuration
| Field | Value |
|---|
| Connection | SQLServer-Prod |
| Package | LoadCustomerData.dtsx |
| Params | {"Region": "West", "Year": 2025} |
Sample Output
| Status | Message | Records Processed |
|---|
| Success | SSIS Package executed | 12500 |
| Success | Data moved to warehouse | 12500 |
