SSIS Framework Editions
SSIS Framework Community Edition is a free, open source project. SSIS Framework Community Edition is designed to demonstrate the value of a simple SSIS Catalog-integrated execution framework.
SSIS Framework Standard Edition (features) is an enterprise SSIS execution framework designed to support Data Integration Lifecycle Management (DILM) executing on a single-server per DILM tier with minimal commercial Framework functionality.
SSIS Framework Professional Edition (features) is an enterprise SSIS execution framework designed to support Data Integration Lifecycle Management (DILM) executing on a single-server per DILM tier.
SSIS Framework Enterprise Edition (features) is an enterprise SSIS execution framework designed to support DILM executing on multiple servers per DILM tier.
|Orchestrate SSIS Applications|
|Execute SSIS Applications with a single command|
|SSIS Catalog-integrated execution|
|Works with SSMS Catalog Reporting|
|Works with DILM Suite Catalog Reports|
|SSIS Catalog-integrated logging|
|SSIS Framework Reporting|
|Restart SSIS Applications at Failed Application Package|
|Application Package Parameter Support|
|Metadata-Driven Data Tap Support|
|Application Package Environment (References) Support|
|Application Package Property Override Support|
|Execute SSIS Applications / Packages on Different / Several Servers|
|Support for “Enterprise Data Integration Farm” SSIS Scale-Out|
|Enterprise Data Integration Reporting|
SSIS Frameworks are designed to support Enterprise Data Integration Lifecycle Management (DILM) by encapsulating SQL Server Integration Services (SSIS) executions into collections of SSIS packages called SSIS Applications.
An SSIS Application is a collection of SSIS packages stored in an SSIS Catalog (available in SQL Server 2012+) configured to execute in a pre-determined order. Metadata about the applications, packages, and their respective orders of execution are stored in a custom schema which is integrated into the SSIS Catalog database (SSISDB).
SSIS Framework Commercial and Enterprise Editions are designed to support enterprise Data Integration DevOps with SSIS. Commercial and Enterprise features like Application Package Parameters that allow DevOps personnel to configure SSIS execution by overriding SSIS Package Parameter values via metadata management. Application Package Parameter support facilitates advanced SSIS Design Patterns like the Generic Stored Procedure Executor pattern.
SSIS Framework Commercial and Enterprise Editions surface Application Package Environments that allow DevOps personnel to select a configured SSIS Catalog Reference at runtime.
SSIS Framework Commercial and Enterprise Editions provide Application Package Property Overrides that allow DevOps personnel to effect SSIS Package execution changes – such as overriding the BLOBTempStoragePath property of a Data Flow Task – without making changes to the SSIS Package!