Execute SSIS
Infoveave Data Automation — Script Execution
Your SSIS packages already work. Execute SSIS runs them inside any Infoveave workflow.
Organizations with established SQL Server data ecosystems have significant investments in SSIS packages — tested ETL workflows that reliably process financial data, ERP extracts, and warehouse operations. Rebuilding these packages from scratch is unnecessary and risky. Execute SSIS preserves that investment by running DTSX packages as a step inside Infoveave workflows, letting you orchestrate SSIS alongside modern API calls, file ingestion, and AI-powered activities in a single unified pipeline. Pass parameters at runtime to make a single package handle multiple data sources or environments.
What Execute SSIS does
Trigger SQL Server Integration Services (SSIS) packages from inside your Infoveave workflow. Run existing DTSX ETL packages without rebuilding them — integrate legacy SQL Server pipelines into modern automated data workflows.
When to use Execute SSIS
- You have existing SSIS packages (.dtsx) that process data and you want to incorporate them into Infoveave workflows
- Your ETL pipeline relies on SQL Server Integration Services and you want to orchestrate SSIS alongside other workflow activities
- You need to pass runtime parameters to an SSIS package — such as source file path, date range, or environment flag — from the workflow
- You are migrating from SSIS as the primary orchestrator to Infoveave, but want to preserve existing packages during the transition
When to avoid it
- You need to run a general SQL query — use Execute Query instead
- You need to run a Java-based ETL job (Talend) — use Execute Talend
- You want to run custom JavaScript automation — use Execute NodeJs
- Your SSIS package is deprecated or you are building a new pipeline — build it natively in Infoveave using the activity library
Where it fits in your Infoveave automation
Execute SSIS is one step inside a multi-step Infoveave workflow. Chain it with other activities — no code, no manual hand-offs.
Build this workflow visually in Infoveave Data Automation — drag, connect, and schedule with no infrastructure setup.
How teams use Execute SSIS
Real scenarios where this transformation saves hours of manual work.
GL Extract and Load
A finance team has an SSIS package that extracts general ledger entries from SAP, applies GAAP mapping transformations, and loads them into the reporting warehouse. Execute SSIS runs this package daily as part of an Infoveave workflow that also sends the loaded record count via Send Email to the finance director — adding orchestration and alerting without touching the SSIS package.
Production Schedule Sync
An SSIS package synchronizes production schedule data from the ERP system to the MES database every morning. Execute SSIS runs this package in an Infoveave workflow that also triggers an OEE dashboard refresh and sends a completion notification — adding workflow context around an unchanged SSIS package.
POS Data Aggregation
Multiple retail store POS systems feed into a daily SSIS aggregation package that normalizes and loads transactions into the data warehouse. Infoveave orchestrates the package execution with runtime parameters for each store's connection, handling parallel execution and error reporting as workflow steps.
See Execute SSIS in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
prod-sqlserver-ssisGLExtract_Daily.dtsx{"SourceEnvironment": "Production", "ReportDate": "2026-04-11"}Input Data
| (connected SQL Server SSIS catalog or .dtsx file) |
Output Data
| (SSIS package execution status — success or failure with error details) |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Connection
The registered SQL Server connection where the SSIS catalog or package file system is hosted. Must be a SQL Server connection configured in Infoveave Studio with appropriate permissions to execute SSIS packages.
Package
The name of the DTSX package file to execute. Can reference a package stored in the SSIS catalog (SSISDB) or a file system path accessible from the Infoveave server. Include path components if the package is in a subfolder.
Params
Optional JSON key-value object of runtime parameters to pass to the SSIS package. These map to SSIS Package Parameters or Project Parameters defined in the package. Use workflow variables to inject dynamic values — such as today's date or a file path from a previous activity.
Frequently asked questions
Everything you need to know about Execute SSIS in Infoveave.
Also in Script Execution — and what runs before & after
Transformations in the same family as Execute SSIS, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Execute SSIS is one of over 80 transformation activities available inside Infoveave workflows. Chain transformations together — no code, no exports, no waiting for IT.
Ready to see Infoveave in action?
