SQL Server Integration Services
learn.microsoft.com
- Windows
- Linux
- API
- Self-hosted
What SQL Server Integration Services is
SQL Server Integration Services (SSIS) is a paid platform for enterprise data integration and transformation. It extracts information from XML, flat files, and relational data sources, transforms it, and loads results into one or more destinations. Teams can use it to copy files, load data warehouses, cleanse and mine data, and manage SQL Server objects and data. Graphical design tools, built-in tasks, and transformations support operations such as aggregation, merging, sorting, distribution, sampling, and lookups. Packages can connect to text, XML, Excel, and relational stores, and can run SQL statements or maintenance tasks. SQL Server Data Tools provides package design, while SQL Server Management Studio manages production packages. The SSIS Catalog stores, runs, manages, and monitors packages. Deployment tools move packages with their dependencies. Packages can also run through Azure-SSIS integration runtimes in Azure Data Factory or Azure Synapse Pipelines. Developers may create packages and custom tasks programmatically.
Who it suits
SSIS suits enterprise teams building data integration, ETL, warehouse loading, cleansing, and SQL Server management workflows. It is intended for organizations able to use paid software and edition-specific capabilities.
Good to know, and what to watch
- Handles extraction, transformation, and loading workflows
- Graphical tools provide built-in tasks and transformations
- Catalog stores, runs, and monitors packages
- Supports custom packages and tasks through programming
- Can run packages through Azure integration runtimes
- Paid product with pricing available on request
- No free plan
- Advanced features vary by SQL Server edition
- SSIS is not included with SQL Server Express
The verdict
SSIS combines graphical package design, extensive data connections, transformations, catalog management, and programmable extensions. Its paid licensing, edition limits, and separate tooling requirements matter when planning deployment.
What the maker publishes
- 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. source
- 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. source
- 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. source
- 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. source
- Data transformations
- Built-in transformations can aggregate, merge, distribute, modify, sort, sample, and look up data, among other operations. source
- Deployment
- SSIS deployment tools can move packages to another computer and manage dependencies such as configurations and files. source
- 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. source
- Development and management
- SQL Server Data Tools is used to develop packages, while SQL Server Management Studio is used to manage packages in production. source
- 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. source
- 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. source
- Extensibility
- Developers can create packages programmatically and write custom tasks and other package objects. source
- 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. source
- 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. source
- Other connectors
- The installation guidance lists optional Microsoft connectors for Oracle, Teradata, and SAP BW. source
- Package design
- It includes graphical tools, built-in tasks and transformations, and an SSIS Catalog database for storing, running, and managing packages. source
- Package management
- The SSIS Catalog database stores, runs, and manages packages; the SSISDB catalog can store, manage, run, and monitor them. source
- 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. source
- Platform and installation
- SSIS is installed through SQL Server Setup on a computer, either by itself or alongside other SQL Server components. source
- Programmability
- Developers can program the Integration Services object model to create packages and custom tasks and other package objects. source
- 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. source
- 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. source
- Support
- The SSIS documentation directs users to the SSIS forum, Stack Overflow, the SSIS team blog, and issue and feature reporting. source
- 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. source
- 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. source
Checked against the maker's pages on 7 Oct 2026.