SQL Server Integration Services
Product
Microsoft's platform for data integration and ETL. It moves, cleans and transforms data with packages that run on SQL Server or in Azure.
Description
SQL Server Integration Services (SSIS) is Microsoft's platform for building enterprise-level data integration and data transformation solutions. It solves business data problems such as copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.
As an ETL tool, SSIS extracts and transforms data from sources such as XML files, flat files and relational databases and loads it into one or more destinations. It offers many built-in tasks for control flow and transformations for data flow. Graphical tools let people build packages without writing code, and an object model allows packages and custom tasks in code. The SSIS Catalog is a database that stores, runs and manages packages.
SSIS is part of SQL Server and installed through SQL Server setup. The page lists the SSIS Integration Runtime in Azure Data Factory as a supported environment, so packages can also run in Azure. The page does not name target users. From the tasks described, data engineers, ETL developers and database administrators use it. SQL Server Agent often schedules package runs as job steps.
| Type | Product |
|---|---|
| Also known as | SSIS, Integration Services |
| Website | learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-ver17 |
| Documentation | learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-ver17 |
Developed by
- Microsoft · Organization
Is a
- Analytics and BI tool · Category
- Developer tool · Category
Related to
- Microsoft SQL Server · Product
- SQL Server Agent · Product
- Azure Data Factory · Product
- Microsoft Fabric · Platform
- Power BI · Product
- SQL Server Analysis Services · Product
Community wiki
Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.
Experts and companies for this topic
Nobody has listed this topic yet. Add it to your profile.
Sources
Maintained by Mirko Peters (Microsoft MVP) · Last updated: