A SQL Server platform for building data integration and transformation workflows, enabling ETL (Extract, Transform, Load) processes that move and reshape data between diverse sources and destinations.
- Visual development environment: SQL Server Integration Services (SSIS) provides a graphical development environment through SQL Server Data Tools (SSDT) and Visual Studio for designing data flows that connect sources such as flat files, databases, REST APIs, and cloud storage to various destinations with transformation logic.
- High-performance execution: The SSIS package execution engine is optimized for high-throughput bulk data movement, making it significantly faster than row-by-row T-SQL processing for large datasets.
- Common use cases: DBAs and data engineers use SSIS for nightly data warehouse loads, database migrations, data quality processes, and synchronization between multiple systems.
-
Package deployment: SSIS packages are deployed to the SSIS Catalog (
SSISDB) on SQL Server, where they can be stored, versioned, and executed through SQL Server Agent, SQL Server Management Studio (SSMS), or the catalog’s execution APIs. - Modern alternatives: While Azure Data Factory, dbt, and Python-based ETL frameworks have become popular for cloud and hybrid environments, SSIS remains a widely used solution for on-premises SQL Server deployments.
- Related terms: ETL, Bulk Loading, SQL Server Agent, Data Warehousing, Azure Data Factory.
