SQL Server Integration Services

Spec sheet

What it does

SQL Server Integration Services is a platform for enterprise data integration and transformation, including copying files, loading data warehouses, cleansing data, and managing SQL Server objects and data.Read 7 Oct 2026 · learn.microsoft.com

Purpose

SSIS is a platform for building enterprise-level data integration and data transformation solutions, including copying files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.Read 7 Oct 2026 · learn.microsoft.com

Deployment

SSIS deployment tools can move packages to another computer and manage dependencies such as configurations and files.Read 7 Oct 2026 · learn.microsoft.com

Security

Package protection levels can protect sensitive data or an entire package using a password, a user key, or database storage; password-based package encryption uses AES with a 256-bit key in current versions described by the page.Read 7 Oct 2026 · learn.microsoft.com

Support

The SSIS documentation directs users to the SSIS forum, Stack Overflow, the SSIS team blog, and issue and feature reporting.Read 7 Oct 2026 · learn.microsoft.com

Azure connections

The Azure Feature Pack lets SSIS packages connect to Azure Blob Storage, Azure HDInsight, Azure Data Lake Store, Azure Synapse Analytics, and Azure Data Lake Storage Gen2.Read 7 Oct 2026 · learn.microsoft.com

Azure execution

An Azure-SSIS integration runtime in Azure Data Factory or Azure Synapse Pipelines can run packages deployed to SSISDB, file system, Azure Files, or SQL Server MSDB on Azure SQL Managed Instance.Read 7 Oct 2026 · learn.microsoft.com

Connections

Packages can connect to data stores including text, XML, and Excel files and relational databases for extracting, loading, lookups, SQL statements, and maintenance tasks.Read 7 Oct 2026 · learn.microsoft.com

Data movement

SSIS extracts and transforms data from sources such as XML files, flat files, and relational data sources, then loads it into one or more destinations.Read 7 Oct 2026 · learn.microsoft.com

Data transformations

Built-in transformations can aggregate, merge, distribute, modify, sort, sample, and look up data, among other operations.Read 7 Oct 2026 · learn.microsoft.com

Design tooling

SSIS Designer is available in SQL Server Data Tools as part of an Integration Services project; SSDT and the appropriate extension are used to design and deploy packages.Read 7 Oct 2026 · learn.microsoft.com

Development and management

SQL Server Data Tools is used to develop packages, while SQL Server Management Studio is used to manage packages in production.Read 7 Oct 2026 · learn.microsoft.com

Edition limits

The feature matrix lists built-in connectors, tasks, transformations, ODBC, Azure, Hadoop/HDFS, and basic profiling for Enterprise and Standard editions, while several advanced sources and transformations are Enterprise-only.Read 7 Oct 2026 · learn.microsoft.com

ETL

SSIS extracts and transforms data from sources such as XML files, flat files, and relational data sources, then loads it into one or more destinations.Read 7 Oct 2026 · learn.microsoft.com

Extensibility

Developers can create packages programmatically and write custom tasks and other package objects.Read 7 Oct 2026 · learn.microsoft.com

Linux support

Microsoft's feature matrix lists Linux support for Enterprise, Standard, and Express editions, and notes that DTSWizard.exe is not provided with SQL on Linux.Read 7 Oct 2026 · learn.microsoft.com

Notable limit

SSIS is not included with SQL Server Express, and installing SSIS alone does not install the tools needed to design and develop packages.Read 7 Oct 2026 · learn.microsoft.com

Other connectors

The installation guidance lists optional Microsoft connectors for Oracle, Teradata, and SAP BW.Read 7 Oct 2026 · learn.microsoft.com

Package design

It includes graphical tools, built-in tasks and transformations, and an SSIS Catalog database for storing, running, and managing packages.Read 7 Oct 2026 · learn.microsoft.com

Package management

The SSIS Catalog database stores, runs, and manages packages; the SSISDB catalog can store, manage, run, and monitor them.Read 7 Oct 2026 · learn.microsoft.com

Package security

Package protection levels can protect sensitive data or the whole package using a password, user key, or server storage; password-based protection uses AES with a 256-bit key.Read 7 Oct 2026 · learn.microsoft.com

Platform and installation

SSIS is installed through SQL Server Setup on a computer, either by itself or alongside other SQL Server components.Read 7 Oct 2026 · learn.microsoft.com

Programmability

Developers can program the Integration Services object model to create packages and custom tasks and other package objects.Read 7 Oct 2026 · learn.microsoft.com

Workflow tasks

Tasks can run packages, programs, and batch files; send emails and messages; work with XML; and access or modify SQL Server objects and data.Read 7 Oct 2026 · learn.microsoft.com

Where Specifiction places it

• ETL and ELT Tools#9 of 187.2
• ETL Software#19 of 287.2