What is Microsoft Integration Services?

byAlooma Team
Updated May 3, 2018

Microsoft SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including ETL packages for data warehousing. This includes data migration, transformation, and integration.

SSIS can retrieve information from a variety of sources and source formats, including relational databases, files, applications, etc. It's extensible, so it is possible to build connectors for other types of data sources and streams. It supports various forms of data manipulation in the data warehouse.

SSIS is a suite of tools and components and aside from the core data migration/transformation/integration tasks, it offers features for connection monitoring, task management/job control, event handling, and more.

SQL Server Integration Services first appeared as part of Microsoft SQL Server in 2005. It replaced an earlier data integration tool, Data Transformation Services (DTS).

Like what you read? Share on
Extract, Transform, Load (ETL)Data IntegrationData Warehousing

Further reading

What is Striim?
Alooma Team • Updated Jul 26, 2018
What is Confluent?
Alooma Team • Updated Jul 24, 2018
Take control of your data for free!
Sign up and get $500 worth of free credits to try Alooma.
Request a Demo