---
title: Execute SSIS
description: Run SSIS packages and retrieve output from SQL Server Integration Services.
category: Execute Packages
tags: [ssis, sql server, etl, data flow, execute]
---

# Execute SSIS

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

---

## Input

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

---

## Sample Input

_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             |

---